Select department_id, MIN (salary)
From employees
Group by department_id
Having MIN (salary) >
(Select MIN (salary)
From employees
Where department_id = 50);
This syntax shows all the departments that have minimum salary greater than department 50.
From employees
Group by department_id
Having MIN (salary) >
(Select MIN (salary)
From employees
Where department_id = 50);
This syntax shows all the departments that have minimum salary greater than department 50.
0 comments:
Post a Comment