Select max(Salary) from employeetable where salary

please tell me the query to get details of the employee
having the second largest salary

Question Posted / shivangi

Answer Posted / shivangi

Select max(Salary) from employeetable where salary < (select
max(salary) from Employeetable)

Is This Answer Correct ?

11 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Define Unique Key?

1014

How do you check sql server is up and running?

1001

How to loop through result set objects using odbc_fetch_row()?

977

how to determine the service pack currently installed on sql server? : Sql server database administration

972

Do you know what are different types of replication in sql server?

1099

How you would rewrite the sql query to return the customerid sorted numerically?

1001

What is instead of trigger sql server?

1002

What is difference between temp table and cte?

1021

Define cursor locking

1009

Equi join and non equi join is possible with sql server?

1022

Why use triggers?

1014

How to backup SQL Server Reporting Services ?

148

How to create a simple user defined function in ms sql server?

1022

Do you know what is a linked server in sql server?

1025

What is the difference between a "where" clause and a "having" clause?

1160