Answers for "write a sql query to print the name of employees having salary in each department order by department in ascending order"

write a sql query to print the name of employees having salary in each department order by department in ascending order

SELECT DEPT_ID, MAX(SALARY) a FROM department GROUP BY DEPT_ID having a>30000;

Posted by: Guest on August-16-2021

Code answers related to "write a sql query to print the name of employees having salary in each department order by department in ascending order"