select a.sal from emp a where 2=(select count(distinct b.sal) from emp b

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

Question Posted / syaam

Answer Posted / syaam

select a.sal from emp a
where 2=(select count(distinct b.sal) from emp b
where a.sal<= b.sal)

for getting nth max sal ..replace 2 by n

all the best

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is coalesce and check constraint in sql server?

1095

What Are the Main Features of SQL Azure?

115

How to create “dependant” parameter “make, model, year”

129

What is self contained multi valued query?

986

Explain different types of collation sensitivity?

963

How much is a sql server license?

934

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

945

What is the recovery model?

972

How to define the name and server for a new dsn?

1086

Explain the creation and execution of a user-defined function in the sql server?

1032

What is user defined stored procedures?

909

How to check if a table is being used in sql server?

944

How to select all columns of all rows from a table with a select statement in ms sql server?

1090

Explain different backup plans?

919

What is the default server name for sql server?

1141