SECOND LARGEST SALARY OF AN EMPLOYEE

CGN007
Posted by CGN007 under Sql Server category on | Points: 40 | Views : 1070
SELECT MAX(emp_salary) FROM employee WHERE emp_salary<(SELECT MAX(emp_salary) FROM employee)

Comments or Responses

Posted by: Ras90it on: 5/30/2012 Level:Starter | Status: [Member] | Points: 10
Here which is table name ? and what is emp_salary & employee ???
give the Syntax of this command
plz explain, waiting for ur reply...

Login to post response