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

How to list all user accounts in oracle?

1069

How to estimate disk space needed for an export job?

1108

How to change system global area (sga) in oracle?

1067

Difference between pre-select and pre-query

1179

What are a cluster and non-cluster index?

1065

Explain the use of Merge statement in oracle 11g

1077

How to write a query with a left outer join in oracle?

1126

What are the different oracle database objects?

1150

How to get a list of all user accounts in the database?

1132

What is meant by an index?

1224

What is Java Pool in Oracle?

1249

What is a nested table and how is it different from a normal table?

1113

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1977

How to lock and unlock a user account in oracle?

1163

Which is better Oracle or MS SQL? Why?

5038