<!-- /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0cm; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";} code {font-family:"Courier New"; mso-ascii-font-family:"Courier New"; mso-fareast-font-family:"Times New Roman"; mso-hansi-font-family:"Courier New"; mso-bidi-font-family:"Courier New";} pre {margin:0cm; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Courier New"; mso-fareast-font-family:"Times New Roman";} @page Section1 {size:612.0pt 792.0pt; margin:2.0cm 42.5pt 2.0cm 3.0cm; mso-header-margin:36.0pt; mso-footer-margin:36.0pt; mso-paper-source:0;} div.Section1 {page:Section1;} -->
Таблица DEPARTMENT состоит из таких полей: MANAGER_IDFIRST_NAME PROFIT
Нам нужно узнать FIRST_NAME и PROFIT всех работников, у которых такой же менеджер, что и у работника с FIRST_NAME = 'ALEX', а PROFIT равен или больше, чем у него.
- select first_name from department where manager_id = (select manager_id from department where first_name = 'ALEX') and first_name <> 'ALEX' union all select profit from department select first_name from department where profit >= (select profit from department where first_name = 'ALEX') and first_name <> 'ALEX';
- select first_name, profit from department where (manager_id = (select manager_id from department where first_name = 'ALEX') and profit >= (select profit from department where first_name = 'ALEX')) and first_name <> 'ALEX';
- select first_name, profit from department where (manager_id, profit) >= ANY (select manager_id, salary from department where first_name = 'ALEX') and first_name <> 'ALEX';
- select first_name, profit from department where (manager_id, profit) in (select manager_id, salary from department where first_name = 'ALEX') and first_name <> 'ALEX';
Для просмотра статистики ответов нужно
залогиниться.