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

sathis raja

• Sep 11th, 2014

We can get 2nd maximum salary of the employees.

VIBHAV MISHRA

• Jun 30th, 2014

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

Answer Question  Select Best Answer