From the following table, write a SQL query to find those employees whose salary is more than any salary of those employees whose job title is ‘PU_MAN’. Exclude job title ‘PU_MAN’
- برمجة سي كيو ال sql
- 2021-09-02
- mhanasmh00489829403
الأجوبة
SELECT employee_id, first_name, last_name, job_id
FROM employees
WHERE salary > ALL
( SELECT salary
FROM employees
WHERE job_id = 'PU_MAN' )
AND job_id <> 'PU_MAN';Sample Output:
employee_id first_name last_name job_id 100 Steven King AD_PRES 101 Neena Kochhar AD_VP 102 Lex De Haan AD_VP 108 Nancy Greenberg FI_MGR 145 John Russell SA_MAN 146 Karen Partners SA_MAN 147 Alberto Errazuriz SA_MAN 168 Lisa Ozer SA_REP 201 Michael Hartstein MK_MAN 205 Shelley Higgins AC_MGR
أسئلة مشابهة
القوائم الدراسية التي ينتمي لها السؤال