830 views
1 votes
1 votes

2 Answers

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.
selected by
0 votes
0 votes
Answer is 4....here 500 is lowest price .so except 500 and null  all remaining rows are counted.

Related questions

3 votes
3 votes
2 answers
4
shikharV asked Dec 8, 2015
1,133 views
Use the following tables for the below queries wherever table $1$ and table $2$ are used:Select *From Table 1Where not exists (Select $T_{2}B$ From Table 2 where $T_{2}B ...