Caros colegas, Executei algumas consultas e leituras e já não tenho mais dúvidas.
Obrigado! 2010/1/4 Ygor Thomaz <ygo...@gmail.com>: > 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). > -- Atc, Ygor Thomaz Website: http://ctrlclabs.blogspot.com/ "Olho por olho e o mundo acabará cego"(Mahatma Gandhi).
