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 is enter substitution variable in oracle?

1061

How to run create database statement again?

1164

What is merge statement used for?

1032

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

2145

What is oracle update statement with inner join ?

1069

what is the scripts in data base?

2161

what is dynamic SGA and static SGA

4426

How do we represent comments in oracle?

1058

What do you understand by a database object? Can you list a few of them?

1021

How to create a table in a specific tablespace?

983

Give the constructs of a package, function or a procedure.

1061

What are dml statements in oracle?

1099

What is system global area (sga) in oracle?

998

How to execute a stored procedure in oracle?

1098

In oracle there is column command, how will you explain that?

1067