379 views
1 votes
1 votes
name salaray
A 1000
B 500
C 600
D 900
E

NULL

select name from employee where salary > ANY(select salary from employee);

how many rows will be fetched??

  • 4
  • 5
  • 6

will B be returned ?as in if 500 is smaller than every other ,so we cant compare 500 with NULL,so it wont be printed ..right??and what about E??will it be printed?

Please log in or register to answer this question.

Related questions

2 votes
2 votes
0 answers
2
iita asked Feb 5, 2017
1,036 views
A) 3B) 2C) 1D) 0
1 votes
1 votes
1 answer
3
richa116 asked Nov 29, 2015
298 views