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

Does group by remove duplicates?

978

What does sign mean sql?

1019

Explain the steps needed to create the scheduled job?

965

What is interval partition?

984

What is schema in sql?

881

What is a clob in sql?

966

Can you selectively load only those records that you need? : aql loader

983

Are sql database names case sensitive?

934

What are the two types of periodical indexes?

886

What are the types of records?

951

What is sap sql anywhere?

969

what is isam? : Sql dba

950

What is varchar data type in sql?

1009

What is the use of %rowtype?

975

How do I view tables in mysql?

913