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

State the difference between local and global temporary tables?

1169

How to how to convert numeric expression data types using the convert() function??

1095

What is de-normalization in sql database administration? Give examples?

1027

What are approximate numeric data types in ms sql server?

1105

What do you understand by mirroring?

1045

What are differences in between sql server 2012 and sql server 2016?

1097

what changed between the previous version of sql server and the current version? : Sql server database administration

1054

Can we add an identity column to decimal datatype?

1042

what are different types of raid configurations? : Sql server database administration

1102

What are the aggregate and scalar functions?

1134

What are the steps you should follow to start sql server in single-user mode?

952

Tell me in brief how sql server enhances scalability of the database system?

1041

What is a database in ms sql server?

1107

What does the not null constraint do?

1178

What are the five characteristics of good data?

973