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 sort the query output in oracle?

1076

defination of bitmap index

2180

What are set operators?

1144

What are the ansi data types supported in oracle?

992

How to turn on or off recycle bin for the session?

1174

What is Segment Advisor in Oracle?

1148

How to delete all rows a table in oracle?

1119

What is transport network substrate (tns) in oracle?

1096

what are the advantages of running a database in archive log mode?

2258

What is the exact use of Collections?

2191

What is oracle used for?

1071

What is the difference between PFILE and SPFILE in Oracle?

1112

What is archive log in Oracle?

1184

What the is the diff between local index and global index. give some example.

1685

What is data block in Oracle?

1151