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

What is a field name?

1017

How to get a list of columns in a view using the "sp_columns" stored procedure?

1086

What are the different types of collation sensitivity?

1176

How to define and use table alias names in ms sql server?

1208

Do you know what is a with(nolock)?

1103

What are the various editions of sql server 2017 that are available in the market?

936

Is it possible to update the views? If yes, how, if not, why?

1082

How do I know if localdb is running?

999

How to list all triggers in the database with sys.triggers in ms sql server?

1125

Explain what is the main purpose of having conversation group?

986

List the data types available in mssql?

1102

Define cross join in sql server joins?

1078

What is change data capture (cdc) in sql server 2008?

1078

How do we Backup SQL Azure Data?

108

What is the contrast amongst drop and truncate?

1078