GATE CSE
First time here? Checkout the FAQ!
x
0 votes
37 views

How many rows will be there in the output of the following query?

asked in Databases by Active (1.9k points)   | 37 views

1 Answer

+1 vote
The second query always returns 0.

Thus, the table returned by second query consists of 1 tuple.

 

Now, exists( table containing single tuple)= true for every employee of 1st relation.

 

Thus, bove query will return all the tuples of the 1st relation.
answered by Veteran (11.6k points)  

So it means that whenever we have an internal query consisting of count() then in case of exists we will always get all tuples because count always return an integer  value.

plz varify?

Yes, I suppose that count() will always return an integer. But, today I will execute the query and let you know the actual outcome.
Top Users Jan 2017
  1. Debashish Deka

    9872 Points

  2. sudsho

    5596 Points

  3. Habibkhan

    5498 Points

  4. Bikram

    5350 Points

  5. Vijay Thakur

    4508 Points

  6. Arjun

    4458 Points

  7. Sushant Gokhale

    4410 Points

  8. saurabh rai

    4236 Points

  9. santhoshdevulapally

    3906 Points

  10. Kapil

    3892 Points

Monthly Topper: Rs. 500 gift card

19,481 questions
24,261 answers
54,211 comments
20,405 users