Write a query that displays the difference between the highest and lowest salaries. Label the column DIFFERENCE.

Questions by zecar   answers by zecar

Showing Answers 1 - 2 of 2 Answers

Manikandan

  • Sep 22nd, 2006
 

select max(sal)-min(sal) as Difference from employee;

Neeraj

  • Nov 7th, 2006
 

You can write the query in the following way.select max(sal)-min(sal) difference from emp;

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions