Results 1 to 2 of 2

Thread: Who can help me in relational algebraic expression and sql statment

  1. #1
    Join Date
    Nov 2008
    Posts
    1

    Who can help me in relational algebraic expression and sql statment

    CREATE TABLE Faculty(
    FacSSN char(11) not null primary key,
    FacFirstName varchar(30) not null,
    FacLastName varchar(30) not null,
    FacCity varchar(30) not null,
    FacState char(2) not null,
    FacZipCode char(10) not null,
    FacRank char(4),
    FacHireDate datetime,
    FacSalary decimal(10,2),
    FacSupervisor char(11),
    FacDept char(6),
    Constraint FacltyFK
    Foreign Key (FacSupervisor)
    references Faculty(FacSSN)
    on delete no action
    on update no action
    )

    Insert into Faculty
    (FacSSN, FacFirstName, FacLastName, FacCity, FacState, FacDept, FacRank, FacSalary, FacSupervisor, FacHireDate, FacZipCode)
    Values ('543-21-0987','VICTORIA','EMMANUEL','BOTHELL','WA','MS','P ROF',120000.0,Null,'15-Apr-1996','98011-2242')

    Insert into Faculty
    (FacSSN, FacFirstName, FacLastName, FacCity, FacState, FacDept, FacRank, FacSalary, FacSupervisor, FacHireDate, FacZipCode)
    Values ( '765-43-2109','NICKI','MACON','BELLEVUE','WA','FIN','PROF' ,65000.00,Null,'11-Apr-1997','98015-9945')

    Insert into Faculty
    (FacSSN, FacFirstName, FacLastName, FacCity, FacState, FacDept, FacRank, FacSalary, FacSupervisor, FacHireDate, FacZipCode)
    Values ('654-32-1098','LEONARD','FIBON','SEATTLE','WA','MS','ASSC' ,70000.00,'543-21-0987','01-May-1994','98121-0094')

    Insert into Faculty
    (FacSSN, FacFirstName, FacLastName, FacCity, FacState, FacDept, FacRank, FacSalary, FacSupervisor, FacHireDate, FacZipCode)
    Values ('098-76-5432','LEONARD','VINCE','SEATTLE','WA','MS','ASST' ,35000.00,'654-32-1098','10-Apr-1995','98111-9921')

    Insert into Faculty
    (FacSSN, FacFirstName, FacLastName, FacCity, FacState, FacDept, FacRank, FacSalary, FacSupervisor, FacHireDate, FacZipCode)
    Values ('876-54-3210','CRISTOPHER','COLAN','SEATTLE','WA','MS','AS ST',40000.00,'654-32-1098','01-Mar-1999','98114-1332')

    Insert into Faculty
    (FacSSN, FacFirstName, FacLastName, FacCity, FacState, FacDept, FacRank, FacSalary, FacSupervisor, FacHireDate, FacZipCode)
    Values ('987-65-4321','JULIA','MILLS','SEATTLE','WA','FIN','ASSC', 75000.00,'765-43-2109','15-Mar-2000','98114-9954')

    A Theta-join operation between Faculty and itself to retrieve faculty members who have a higher salary than their supervisor.

    who can help thanks!!need urgently..

  2. #2
    Join Date
    Mar 2003
    Location
    NJ
    Posts
    201
    Try this.


    SELECT a.* FROM Faculty a INNER JOIN Faculty b ON a.FacSupervisor = b.FacSSN
    WHERE ISNULL(a.FacSalary,0) > ISNULL(b.FacSalary,0)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •