select max(salary) from employee where salary != (select max (salary) from

To find second largest salary in Employee table

Question Posted / amit

Answer Posted / amit

select max(salary) from employee where salary != (select max
(salary) from employee)

Is This Answer Correct ?

4 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How can we determine what objects a user-defined function depends upon?

1017

Determine when to use stored procedure to complete sql server tasks?

1055

How data can be copied from one table to another table?

950

What is a trigger in sql server?

1178

Can a synonym name of a table be used instead of a table name in a select statement?

1039

What is @@rowcount in sql?

1009

Explain the steps to create and execute a user-defined function in the sql server?

975

Delete duplicate rows without using rowid.

1538

Differentiate between delete and truncate.

1065

Tell me what is difference between clustered and non clustered index?

944

What is user defined stored procedures?

948

what is create database syntax? : Sql server database administration

1112

What is the difference between insensitive and scroll cursor?

1165

Why union all is faster than union?

913

How to replace null values in expressions using isnull()?

1106