Select min(sal) from table_name where sal in(Select top 2 sal from table

how to find the second highest salary from emp table?

Question Posted / velmurugan p

Answer Posted / velmurugan p

Select min(sal) from table_name where sal in(Select top 2 sal from table_name)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

what are the types of subquery? : Sql dba

1111

Is nosql faster than sql?

1030

What is pivot table in sql?

1115

How to process query result in pl/sql?

1136

what is table? : Sql dba

1069

What are different joins used in sql?

1061

Is left join inner or outer by default?

1026

how would you enter characters as hex numbers? : Sql dba

991

Determine if oracle date is on a weekend?

1042

How many types of cursors are available in pl/sql?

1112

What is t-sql? : Transact sql

993

Mention what pl/sql package consists of?

1006

What is a pragma statement?

1267

How can you load multi line records? : aql loader

1082

What is sql performance tuning?

927