select min(sal) from table_name where sal in (SELECT top 2 sal FROM tab

how to find the second highest salary from emp table?

Question Posted / surendra sharma

Answer Posted / surendra sharma

select min(sal) from table_name where sal in

(SELECT top 2 sal FROM table_name order by sal desc)

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the basic sql commands?

1086

Does sql*plus have a pl/sql engine?

1067

What are the properties of a transaction?

1128

Why we use pl sql?

957

What's the procedure?

925

How to rename a table?

1012

How many types of relationship are there?

1027

Is sql dba a good career? : SQL DBA

987

what is heap table? : Sql dba

1103

explain normalization concept? : Sql dba

1045

Does sql view stored data?

955

what is row? : Sql dba

1224

Are stored procedures compiled?

917

Can procedure in package be overloaded?

1083

what is an index? : Sql dba

991