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

Explain the truncate command?

920

What is multi-statement table-value user-defined function?

938

What is clustered index

954

What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas

924

What is the difference between for auto and for nested?

934

Explain features and concepts of analysis services?

934

How to concatenate two character strings together?

1058

What is service broker?

957

What are data regions?

121

How do I find the sql server database version?

942

What is meant by referential integrity?

959

What is normalization according to you and explain its different levels?

900

What the different types of Replication and why are they used?

981

What is inner join? Explain with an example?

1120

Write a SQL command to insert and update only a particular field?

1040