select max(salary) from table where salary<(select max (salary) from ta

can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com

Question Posted / kumar_kisna

Answer Posted / kumar_kisna

select max(salary) from table where salary<(select max
(salary) from table)

Is This Answer Correct ?

4 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Find first and last day of current month in sql server

1028

How to delete existing rows in a table?

1158

Write a query to find 5th highest amount paid from the customer table.

934

Can we call future method from trigger?

937

How to encrypt Strored Procedure in SQL SERVER?

1167

What is the difference between a clustered index and a non-clustered index?

991

What is the standby server?

953

Define right outer join in sql server joins?

1046

Can sql servers link to other servers like oracle?

842

What is nested transaction?

1101

How can you start sql server in different modes?

969

List the types of recovery model available in sql server?

928

How adventureworkslt tables are related?

926

What are the types of database recovery models?

1123

Explain powershell included in sql server 2008?

1055