Sql query

What is sql query to retrieve the second effective employees from job data for all the employees?

Questions by venkateshm

Showing Answers 1 - 6 of 6 Answers

VIBHAV MISHRA

  • Jun 30th, 2014
 

Select max(Sal) from Emp Where Sal not in(Select max(Sal) from Emp)

  Was this answer useful?  Yes

sathis raja

  • Sep 11th, 2014
 

we can get 2nd maximum salary of the employees.

  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