Download 100% FREE Office Document APIs for .NET
DotNetFunda.com
Online: 747
Home > Codes >

SECOND LARGEST SALARY OF AN EMPLOYEE

CGN007
Posted by CGN007 under Sql Server category on | Points: 40 | Views : 1153
Post Code | Search Codes | Code Home  
SELECT MAX(emp_salary) FROM employee WHERE emp_salary<(SELECT MAX(emp_salary) FROM employee)
Alert Moderator 
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