select ename,sal.rn from(select ename,sal,rownum rn from(select ename,sal f

Write a query to find second highest salary of an employee.

Question Posted / gyana ranjan behera

Answer Posted / gyana ranjan behera

select ename,sal.rn from(select ename,sal,rownum rn from(select ename,sal from emp order by sal desc))where rn=2;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What does cursor do in sql?

1067

What is synonyms?

1118

Explain correlated query work?

1107

Can cursors be part of a trigger body?

1693

Is crud a cuss word?

1073

Which is better join or subquery?

1190

What is a crud api?

992

Which is better trigger or stored procedure?

1014

In a distributed database system, can we execute two queries simultaneously?

1155

What is crud sql?

1028

What is crud diagram?

993

what is meant by nl2br()? : Sql dba

1107

What is the difference between rollback and rollback to statements?

1099

what is a constraint? Tell me about its various levels. : Sql dba

1049

Explain the update statement in sql

1044