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 schema means?

843

Why sql query is slow?

928

What are the most important ddl statements in sql?

1024

What are the benefits of pl/sql packages?

1031

What is flag in sql?

980

What is a left inner join?

943

How to change sql*plus system settings?

993

What are the advantages of normalization?

1035

What is faster join or subquery?

958

What is the use of sqlerrd 3?

889

List the different type of joins?

997

Can we use ddl statements in stored procedure?

1094

How to set up sql*plus output format in oracle?

971

How do I partition a table in sql?

1039

what is innodb? : Sql dba

1030