1 votes 1 votes Consider the following instance R. A 1 2 3 4 B Null 1 2 2 The number of tuples returned by the following SQL query is _____________. > select * from R as R1 where not exists (select * from R) where B = R1.A Databases databases sql virtual-gate-test-series + – Naveen K Verma asked Jan 10, 2018 • edited Apr 2, 2019 by Lakshman Bhaiya Naveen K Verma 714 views answer comment Share Follow See all 11 Comments See all 11 11 Comments reply Show 8 previous comments hs_yadav commented Jan 10, 2018 reply Follow Share yes undefined .... let comparison is like this.... any Number =NULL (here we r not sure about the value of NULL therefor False) Number>NULL(again we r not sure about the value of NULL therefor False) Number<NULL(again we r not sure about the value of NULL therefor False)..... therefor we say that the comparison with NULL gives undefine ... 0 votes 0 votes Ashwin Kulkarni commented Jan 10, 2018 reply Follow Share Then NOT exist (undefined) will not return any rows 0 votes 0 votes sai charan chakrala commented Feb 6, 2019 reply Follow Share I think the answer should be 2 as the two tuples with A as 3 and 4 should be returned as they do not have an equivalent value in B. 0 votes 0 votes Please log in or register to add a comment.
0 votes 0 votes there is a mistake in parathezisation...it will be 2 Psy Duck answered Oct 30, 2022 Psy Duck comment Share Follow See all 0 reply Please log in or register to add a comment.