Question

write a query to display min and max salaries of each job if min sal is more than 1000 and max sal is less than 5000​

Answer 1

Answer:

SELECT DEPTNO, MAX(SAL) FROM EMP WHERE JOB <>'CLERK' GROUP BY DEPTNO HAVING MAX(SAL)>1500 ORDER BY DEPTNO DESC;

Explanation: