GATE CSE
First time here? Checkout the FAQ!
x
0 votes
51 views
Select      SNAME
from        S
Where       SNOin
            (select     SNO
            from        SP
            where       PNOin
                        (select     PNO
                        from        P
                        Where       COLOUR='BLUE'))

What relations are being used in the above SQL query? Given at least two attributes of each of these relations.

asked in Databases by Veteran (79.1k points)   | 51 views

1 Answer

0 votes
relation S(sname , sno) and relation P(pno,colour)
answered by Junior (541 points)  


Top Users Aug 2017
  1. Bikram

    4892 Points

  2. ABKUNDAN

    4704 Points

  3. akash.dinkar12

    3480 Points

  4. rahul sharma 5

    3158 Points

  5. manu00x

    3012 Points

  6. makhdoom ghaya

    2470 Points

  7. just_bhavana

    2382 Points

  8. stblue

    2130 Points

  9. Tesla!

    2066 Points

  10. joshi_nitish

    1758 Points


25,009 questions
32,131 answers
74,802 comments
30,179 users