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 do you mean by “trigger” in sql?

1054

Explain the difference between sql and mysql.

1040

What is the difference between function and procedure in pl/sql?

1054

what are different types of keys in sql?

1126

What does rownum mean in sql?

1008

What does desc stand for?

1057

Do we need commit after truncate?

1063

what does myisamchk do? : Sql dba

1001

What is the purpose of a secondary key?

937

What is an ndf file?

973

What is the difference between joins?

1021

what are the different functions in sorting an array? : Sql dba

1001

What is procedure function?

1037

What are the various levels of constraints?

1113

Is join and inner join the same?

989