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 is a ddl command?

1093

What is bind reference and how can it be created?

1021

How do I run a sql trace?

963

Enlist some predefined exceptions?

1063

What are stored procedures in mysql?

1019

Mention what plvcmt and plvrb does in pl/sql?

1143

What is type and rowtype in pl sql?

1020

What is latest version of sql?

1048

Enlist the characteristics of pl/sql?

1804

Is null operator in sql?

1043

Why do we need cursors in pl sql?

1088

What are different types of triggers?

1114

How is use pl and sql?

1068

Where do we use pl sql?

1002

What are sql data types?

1032