select * from ( SELECT ROWNUM as RANK, ename, sal FROM (SELECT ename,sa

find the third highest salary?

Question Posted / gautam

Answer Posted / gautam

select * from (
SELECT ROWNUM as RANK, ename, sal
FROM (SELECT ename,sal FROM emp ORDER BY sal DESC)
WHERE ROWNUM <= 3)
where rank=3

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

979

what are the 'mysql' command line options? : Sql dba

1058

What are system versioned tables?

1010

Can we create view in stored procedure?

944

What is pl sql and why it is used for?

1099

what is a database transaction? : Sql dba

1153

what is the difference between delete and truncate statement in sql? : Sql dba

1213

Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

1009

What is anonymous block in sql?

1107

what is a database? : Sql dba

1143

What are the 3 types of behavioral triggers?

1233

Define the select into statement.

1038

What are the benefits of stored procedures?

1047

What is procedure explain with example?

939

How many joins in sql?

983