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??
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?