sql>select ename,sal from(select ename,sal,rownum rn from (

find the second highest salary of the emp table

Question Posted / gyana ranjan behera

Answer Posted / gyana ranjan behera

sql>select ename,sal 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 do you know about normalization? Explain in detail?

934

How to declare a local variable?

1097

How to best split csv strings in oracle 9i?

1023

How to delete an existing row from a table in oracle?

1052

What is tns service name?

1109

How to get execution path reports on query statements?

966

How to select some rows from a table in oracle?

1055

What is materialized view in Oracle?

1060

How to create an oracle database?

1014

How to add another datafile to a tablespace?

1017

Explain oracle instance.

1157

Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?

987

What is an oracle function?

1133

When do we use group by clause in a sql query?

1024

How to view existing locks on the database?

1031