select top 1 salary from(select top 3 salary from emp order by desc) a

find out the third highest salary?

Question Posted / nitin berwal

Answer Posted / nitin berwal

select top 1 salary from(select top 3 salary from emp order
by desc) a

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to create an oracle database?

1039

What is translate in oracle?

1096

How to recover a dropped table in oracle?

1042

How to add a new column to an existing table in oracle?

1139

Please explain oracle left join with an example?

1043

How many categories of data types?

993

What is primefaces used for?

1047

What is parameterized cursor in oracle?

1148

Why does oracle 9i treat an empty string as null?

1054

How to use group functions in the select clause using oracle?

1070

What is an oracle recycle bin?

1009

what are actual and formal parameters?

1104

What is background process in Oracle?

1099

Difference between oracle's plus (+) notation and ansi join notation?

1100

What is the difference between primary key and unique key and foreign key in oracle?

974