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

What is the difference between ddl and dml?

1050

what are the different types of SSRS reports?

153

What is normalization and its types?

1040

What are the different types of normalization?

1167

How do you test your database? : sql server database administration

1026

What is deploy, process and build? : sql server analysis services, ssas

1112

Is truncate a dml command?

956

Can sql servers linked to other servers?

1048

Explain about SQLOS?

1013

How to run queries with sql server management studio express?

1095

Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture

1067

What is a view and what are its advantages?

1114

What is the command used to check locks in microsoft sql server?

1045

How to get the definition of a stored procedure back?

977

What are different types of statement?

1019