Awesome q2a theme
0 votes
18 views

Coaching (cname, city)

Travel (name, city)

Select T1.name from Travel T1 where Not Exist (Select M.city FROM Coaching M where M.cname = “madeeasy”  EXCEPT  Select T2.city from Travel T2 where T1.name = T2.name)

The above query returns the name of the person – 

  1. who have not travelled in any city where madeeasy is located.
  2. who have travelled in all city where madeeasy is located.
  3. who have travelled in at least one city where madeeasy is located.
  4. who have not travelled in all city where madeeasy is located.

N.B – This is a 1 mark question.

in Databases by (32 points) | 18 views
0

Ans given as B ?

0
yes, but how much time did you take & how to do it fast ???
0

see the not exist , when it will be true when the given part which is inside bracket is empty. Now try to make the inside  part empty and you will find out that it will be empty only when a person has travelled all the cities where Made easy is located.

Please log in or register to answer this question.

Welcome to GATE CSE Doubts, where you can ask questions and receive answers from other members of the community.
Top Users Oct 2019
  1. GAITONDE

    410 Points

  2. Satbir

    317 Points

  3. Rudr Pawan

    163 Points

  4. srestha

    136 Points

  5. Mk Utkarsh

    127 Points

  6. Debapaul

    94 Points

  7. chandrikabhuyan8

    87 Points

  8. Shaik Masthan

    79 Points

  9. Verma Ashish

    77 Points

  10. !KARAN

    74 Points

Monthly Top User and those within 60% of his/her points will get a share of monthly revenue of GO subject to a minimum payout of Rs. 500. Current monthly budget for Top Users is Rs. 450.
1,680 questions
1,090 answers
4,561 comments
89,591 users