SECOND LARGEST SALARY OF AN EMPLOYEE

Posted by CGN007 under Sql Server category on 5/30/2012 | Points: 40 | Views : 1258

SELECT MAX(emp_salary) FROM employee WHERE emp_salary<(SELECT MAX(emp_salary) FROM employee)

Bookmark It

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...

Latest Code Snipptes