1 votes 1 votes consider the following table T A B 1 5 2 10 3 15 SELECT * FROM T WHERE EXISTS (SELECT COUNT(*) FROM T WHERE B=2); NO. of rows returned by above query__________ dushyantsingh asked Jul 8, 2017 dushyantsingh 268 views answer comment Share Follow See all 0 reply Please log in or register to add a comment.
0 votes 0 votes The EXISTS operator returns true if the sub-query returns one or more records. Since sub-query gives count =0; it will return all three rows. vijay_jr answered Jul 8, 2017 vijay_jr comment Share Follow See all 0 reply Please log in or register to add a comment.