1 votes 1 votes Databases sql databases + – Arnabi asked Oct 17, 2017 Arnabi 830 views answer comment Share Follow See all 5 Comments See all 5 5 Comments reply Show 2 previous comments joshi_nitish commented Oct 17, 2017 reply Follow Share except Americano and Tea tupple, every tupple will be selected 0 votes 0 votes Arjun commented Oct 17, 2017 reply Follow Share Tried it? 0 votes 0 votes akash.dinkar12 commented Oct 17, 2017 reply Follow Share except for Americano and Tea tuple, every tuple will be selected and output will be 4 rows 1 votes 1 votes Please log in or register to add a comment.
Best answer 1 votes 1 votes answer is 4.Here lowest price is 500.So all tuples with price >500 will be selected.So price of 1000,900,1500,600 will be selectd.But comparison with NULL will give UNKNOWN.so price with NULL value will not be selected. Sambit Kumar answered Oct 17, 2017 selected Oct 17, 2017 by Arnabi Sambit Kumar comment Share Follow See all 3 Comments See all 3 3 Comments reply mohitbawankar commented Oct 17, 2017 reply Follow Share if we choose price 900 then? bcs they didn't mentioned lowest price or highest price right ? 0 votes 0 votes Sambit Kumar commented Oct 17, 2017 reply Follow Share >ANY means greater than any value in the set.that is why we need to consider lowest value in the set. 0 votes 0 votes mohitbawankar commented Oct 17, 2017 reply Follow Share ok thanks 0 votes 0 votes Please log in or register to add a comment.
0 votes 0 votes Answer is 4....here 500 is lowest price .so except 500 and null all remaining rows are counted. sudhir singh answered Nov 13, 2017 sudhir singh comment Share Follow See all 0 reply Please log in or register to add a comment.