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

1 Answer

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


Top Users Mar 2017
  1. rude

    5236 Points

  2. sh!va

    3054 Points

  3. Rahul Jain25

    2920 Points

  4. Kapil

    2732 Points

  5. Debashish Deka

    2602 Points

  6. 2018

    1574 Points

  7. Vignesh Sekar

    1422 Points

  8. Akriti sood

    1402 Points

  9. Bikram

    1374 Points

  10. Sanjay Sharma

    1128 Points

Monthly Topper: Rs. 500 gift card

21,545 questions
26,881 answers
61,232 comments
23,243 users