select rownum as maxsal,sal from (select sal from emp order by sal desc)

find out the third highest salary?

Question Posted / mamta

Answer Posted / mamta

select rownum as maxsal,sal
from (select sal from emp order by sal desc)
where rownum <4

Is This Answer Correct ?

0 Yes

6 No

Please Help Members By Posting Answers For Below Questions

What is an anonymous block?

1327

Explain oracle 12c new features for developers?

1125

Explain coalesce function?

1251

Explain a segment?

1131

what is dynamic SGA and static SGA

4491

Explain oracle instance.

1234

What is MTTR advisor in Oracle?

1141

What is a cursor variable?

1216

How to list all indexes in your schema?

1142

What is a private synonym?

1647

What is a relational database management system?

1172

Is there a combination of "like" and "in" in sql?

1116

How to start an oracle instance?

1076

How to convert csv to table in oracle?

1048

How to open a cursor variable?

1089