edited by
273 views
0 votes
0 votes

consider following relation

 

How many number of records resulted by following SQL query?

Select   $T_{1}.A$

From R

Where Exists (Select Count (*) From S Where R .C<S.F and S. E > 10 );

 

A   3

B    2

C   1

D    0

edited by

Please log in or register to answer this question.

Related questions

0 votes
0 votes
2 answers
2
atulcse asked Jan 16, 2022
771 views
Consider the following relations:How many number of records will be returned by the following query?
0 votes
0 votes
0 answers
4
amitqy asked Jan 8, 2019
486 views
I got why query 2 is wrong. How do I approach to understand Query 1, is there a generic approach for solving questions like these which have no tables given?