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

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

Question Posted / elumalai.k

Answer Posted / elumalai.k

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

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is database black box testing?

1017

What is the use of sign function?

1092

How you can find out if an index is useful to the optimizer?

921

How can you hide the sql server instances?

1003

What are the different types of subquery?

1133

What is difference between rollback immediate and with no_wait during alter database?

1064

Do you know what is openxml in sql server?

1051

What is the use of keyword with encryption. Create a store procedure with encryption?

945

What are Spatial data types in SQL Server 2008

1000

What is right outer join in sql server joins?

1157

How do I view a script in sql server?

1027

How do you clear a log file?

1031

What is a fan-out query in SQL Azure?

121

Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication

970

Define self join in sql server joins?

935