select max(sal) from tablename where sal<(select max(sal)from tablename

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

Question Posted / divya

Answer Posted / divya

select max(sal) from tablename where sal<(select
max(sal)from tablename)

Is This Answer Correct ?

3 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to get the definition of a stored procedure back?

922

What are Row versions of DataRow?

978

Which is faster statement or preparedstatement?

894

What is normalization and its types?

966

Why is the need for data conversion transformations?

980

How to assign null values to variables or columns?

915

What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

951

How display code or Text of Stored Procedure using Sql query in Sql Server ?

1070

What is difference between commit and rollback when used in transactions?

909

Tell me what is fill factor?

908

Tell me what is sql profiler?

982

What is difference between count (*) and count column?

841

What is abstracting periodical?

896

Do you know the different ddl commands in sql?

1000

You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date

992