Select top 2 sal from (select sal from emp order by sal desc)

how to find the second highest salary from emp table?

Question Posted / sheela

Answer Posted / sheela

Select top 2 sal from (select sal from emp order by sal
desc)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Is sql injection illegal?

1082

What is secondary key?

989

Why commit is not used in triggers?

1091

Can you inner join the same table?

1039

What are the built in functions of sql?

1096

Can we create a trigger on view?

946

What are keys in sql?

1043

How to read/write files from pl/sql?

1085

Is sqlite good enough for production?

1049

define sql update statement ? : Sql dba

1159

What is nosql vs sql?

1227

What is data types in sql?

1070

What are the datatypes available in pl/sql ?

1155

What is compute?

1152

How do I view a view in sql?

996