GATE CSE
First time here? Checkout the FAQ!
x
0 votes
63 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 (92.5k points) 967 2328 3115 | 63 views

1 Answer

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


Quick search syntax
tags tag:apple
author user:martin
title title:apple
content content:apple
exclude -tag:apple
force match +apple
views views:100
score score:10
answers answers:2
is accepted isaccepted:true
is closed isclosed:true
Top Users Oct 2017
  1. Arjun

    23346 Points

  2. Bikram

    17058 Points

  3. Habibkhan

    8142 Points

  4. srestha

    6254 Points

  5. Debashish Deka

    5438 Points

  6. jothee

    4968 Points

  7. Sachin Mittal 1

    4772 Points

  8. joshi_nitish

    4298 Points

  9. sushmita

    3964 Points

  10. Rishi yadav

    3794 Points


Recent Badges

100 Club Vamp thehacker
Popular Question LavTheRawkstar
Notable Question shubham vashishtha
Nice Answer Habibkhan
Good Question jenny101
Regular Ashish Subscription
Famous Question Akash Kanase
Photogenic guptasaurabh9868
Nice Question Nishant Arora
Notable Question gabbar
27,301 questions
35,154 answers
83,985 comments
33,244 users