Select max(salary) from employee where salary not in (select max(salary) f

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

Question Posted / arun ashok

Answer Posted / arun ashok

Select max(salary) from employee where salary not in (select
max(salary) from employee)

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Do you know what is bit data type and whats the information that can be stored inside a bit column?

940

What is the difference between migration and upgradation in sql server?

1079

What is collation sensitivity?

1035

How many cores do I need for sql server 2016?

872

What do you understand by integration services in sql server?

941

How to use copy and concatenate commands in SQL?

1115

What is BCP? When does it used in sql server 2012?

1042

How to list all triggers in the database with sys.triggers in ms sql server?

1055

What is view in sql?

881

What is self contained scalar sub query?

956

How many replicas are maintained for each sql azure db?

124

Can you always create a cache of a report?

171

What is the user of Primary key?

958

what is a default tcp/ip socket assigned for sql server? : Sql server database administration

1035

How to locate and take substrings with charindex() and substring() functions?

991