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

Is there any difference between primary key and unique with the not null condition?

958

What is the difference between insensitive and scroll cursor?

1169

What is the parse query button used for?

1042

what is blocking? : Sql server database administration

1050

Explain the concepts and capabilities of sql server?

984

Why the trigger fires multiple times in single login?

1220

What is the difference between a stored procedure and a user defined function?

1031

Is it possible to have clustered index on separate drive from original table location?

972

What options are available to audit login activity? : sql server security

1159

what do you understand by change data capture?

1034

Why do we use stored procedures in sql server?

954

What is the xml datatype?

1086

What is policy management?

1008

What is sql server database?

1022

What are the High-Availability solutions in SQL Server and differentiate them briefly?

1153