select rownum,name,salary from (select name,salary from employee

How to retrieve 5th highest sal from emp table?

Question Posted / arvind patil

Answer Posted / arvind patil

select rownum,name,salary
from (select name,salary
from employee
order by salary desc )
where rownum=5;

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain the difference between sap and oracle?

1086

hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards

2047

what is Single Byte Overhead...?

2613

Can we convert a date to char in oracle and if so, what would be the syntax?

1063

What are the components of logical database structure in oracle database?

1137

What are temporal data types in oracle?

1168

How do I manually uninstall oracle client?

1151

Explain about the analyze command in oracle?

1112

What is PL/SQL ?

2220

Why packages are used in oracle?

1118

What is a cursor variable?

1215

How to use "out" parameter properly?

1124

How many categories of data types?

1043

How to get the Installed Oracle Version Information ?

1189

What is coalesce function?

1146