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

‘Order by’ is not allowed in a view how can you sort information from a view?

1070

How to create a user name in a database?

1031

Why people hate cursor?

1129

What is the difference between a view and a stored procedure?

1018

What do you mean by normalisation?

1014

What is cdc in sql server?

985

What kind of problems occurs if we do not implement proper locking strategy?

1386

How important do you consider cursors or while loops for a transactional database?

947

Â Explain what is sql override for a source taLle in a mapping?

988

Explain what is lock escalation and what is its purpose?

917

What is reference section?

985

Is null vs coalesce?

849

Give main differences between "Truncate" and "Delete".

1074

How to check if stored procedure is running in sql server?

1028

What does this statement do @@rowcount?

954