select sal from(select sal from (select distinct sal from emp o

how to find the second highest salary from emp table?

Question Posted / dinesh rajput

Answer Posted / dinesh rajput

select sal from(select sal from
(select distinct sal from emp order by sal desc)
where rownum<=2 order by sal asc)
where rownum=1;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are tables in sql?

1120

what is isam? : Sql dba

1067

What is null in pl/sql?

1121

Which join is default?

1017

How do you use a while loop in pl sql?

1056

describe mysql connection using mysql binary. : Sql dba

1124

What is a call statement? Explain with an example.

1071

Why is the cursor important?

1082

How can we implement rollback or commit statement in a trigger?

1085

What is group function in sql?

1067

Does sql*plus have a pl/sql engine?

1132

What is a loop in sql?

1037

what is self-join? : Sql dba

1244

What are hotfixes and patches?

987

Does sql support programming?

1116