select min(sal) from (select sal from emp order by sal desc) where rownu

find the third highest salary?

Question Posted / satish prajapati

Answer Posted / satish prajapati

select min(sal) from (select
sal from emp order by sal
desc) where rownum <= 3

Is This Answer Correct ?

2 Yes

4 No

Please Help Members By Posting Answers For Below Questions

how to use case expression? : Sql dba

998

How do I run sql?

1148

What is foreign key in sql with example?

910

What is sqlcontext?

1059

what are the drivers in mysql? : Sql dba

1006

What is memory optimized table?

1030

how would you enter characters as hex numbers? : Sql dba

968

How do I view stored procedures?

957

What is pls_integer in pl sql?

1073

How to handle bulk data?

1298

Write a query to find the names of users that begin with "um" in sql?

970

What is the sql*loader? : aql loader

1039

What is an oracle stored procedure?

1028

What is full join in sql?

972

How do I restart sql?

949