select ename, salary from (Select ename, salary, rownum FROM emp where

Find out the 3rd highest salary?

Question Posted / xxx

Answer Posted / xxx

select ename, salary from
(Select ename, salary, rownum
FROM emp where rownum<=3
Order by salary )
where rownum = 1
;

Is This Answer Correct ?

7 Yes

20 No

Please Help Members By Posting Answers For Below Questions

What are all the ddl commands?

1193

What is input buffer in sql*plus?

1239

How do I run a program in pl sql?

1013

explain the advantages and disadvantages of stored procedure? : Sql dba

1022

What is the maximum number of triggers, you can apply on a single table?

1007

Is primary key is clustered index?

1006

Explain what is a field in a database and record in a database?

1103

Advantages and disadvantages of stored procedure?

1130

What are the dml statements?

1151

What is the need of merge statement?

1050

Should I use mbr or gpt?

1034

What is the usage of nvl function?

1045

how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba

1354

How does an execution block start and end in pl sql?

959

What is sql*loader?

1203