Pessoal,

alguem pode dar uma explicadinha sobre a questão abaixo ?

Which of the following statements are equivalent? (Choose two answers.)
A. select employee_id from employees where salary < all (select salary
from employees where
department_id=10);
B. select employee_id from employees where salary < (select
min(salary) from employees
where department_id=10);
C. select employee_id from employees where salary not >= any (select
salary from employees
where department_id=10);
D. select employee_id from employees e join departments d on e.department_id=
d.department_id where e.salary < (select min(salary) from employees) and
d.department_id=10;

Não consegui entender pra valer ainda as relação de comparação usando:
< ANY, > ANY,  > ALL, < ALL.

Obrigado!

-- 
Atc, Ygor Thomaz
Website: http://ctrlclabs.blogspot.com/
"Olho por olho e o mundo acabará cego"(Mahatma Gandhi).

Responder a