1.

List the minimum and maximum salary of each job type.

Answer»

SELECT job,MIN(sal),MAX(sal) FROM emp GROUP BY job;



Discussion

No Comment Found

Related InterviewSolutions