SECOND LARGEST SALARY OF AN EMPLOYEE

CGN007

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

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

Alert Moderator

GooglePlus

StumbleUpon

Delicious

Reddit

Email

Bookmark It

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

Latest Code Snipptes