SELECT * FROM EMP WHERE SAL =(SELECT MIN(SAL) FROM EMP WHERE SAL IN (SELECT

How to read 2nd highest sal from EMP table?

Question Posted / gali kondareddy

Answer Posted / gali kondareddy

SELECT * FROM EMP WHERE SAL =(SELECT MIN(SAL) FROM EMP WHERE SAL IN (SELECT TOP 2 SAL FROM EMP ORDER BY SAL DESC))

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Define cursor locking

1006

Do you know what is xpath?

1088

What are character string data types in ms sql server?

1251

What is the data type of time?

963

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

1108

What is transaction server isolation?

1039

How to create hyperlink from returned sql query ?

1125

What is extended stored procedures?

966

Is mysql better than sql server?

1059

What is normalization 1nf 2nf 3nf?

1060

How many categories of functions based their return modes?

1103

Can a trigger be created on a view?

956

Can we perform backup restore operation on tempdb?

1015

What is sql server management studio? : sql server management studio

1074

what is the difference between delete table and truncate table commands? : Sql server database administration

1033