GATE CSE
First time here? Checkout the FAQ!
x
0 votes
30 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 (75.6k points)   | 30 views

1 Answer

0 votes
relation S(sname , sno) and relation P(pno,colour)
answered by Junior (531 points)  
Top Users Feb 2017
  1. Arjun

    5490 Points

  2. Bikram

    4266 Points

  3. Habibkhan

    3972 Points

  4. Aboveallplayer

    3126 Points

  5. Debashish Deka

    2646 Points

  6. sriv_shubham

    2328 Points

  7. Smriti012

    2270 Points

  8. Arnabi

    2114 Points

  9. sh!va

    1780 Points

  10. mcjoshi

    1702 Points

Monthly Topper: Rs. 500 gift card

20,905 questions
26,051 answers
59,775 comments
22,189 users