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

How many clustered indexes there can be on table ?

1004

What are the instances when triggers are appropriate?

942

What is server-level principal?

120

How to find which stored procedure is currently running in sql server?

937

Explain what is lock escalation?

1008

What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration

988

What does the on update no action do?

979

Where sql server user names and passwords are stored in sql server? : sql server database administration

1012

What is the purpose of grouping data in a report?

923

Explain the concept of view and Types of views in SQL server?

948

What will be query used to get the list of triggers in a database?

964

What is SQL Server?

1162

What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

4322

What are the types of sql server?

1008

What do we have to check in database testing?

983