Answer / chandrasekar.ramasamy

select sal from( select rownum,e.* from empmaster e order
by sal desc) where rownum < 4

Answer / dhiman sarkar

select empname,sal from (select empname,sal from dh1 order
by sal desc)
where rownum < =4
order by sal desc

Answer / kalyan kumar

select e.ename,e.sal from emp e where 3>(select count
(distinct(b.sal)) from emp b where b.sal>e.sal)

Answer / vik

select empno, ename, sal from (select * from emp order by
sal desc) where rownum < 4

Answer / nilesh

You can also use a query like

select e.ename,e.sal from emp e where 3>(select count
(distinct(b.sal)) from emp b where b.sal>e.sal)

as explained by Kalyan Kumar in Answer 2 and for making
it parameterised u can replace 3 by &sal so that when it is
executed it will ask you a number
if you enter 3 it will give you best three salaries , if
you enter 4 it will give you best 4 salaries etc.

Answer / rameshwar gupta

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

Answer / moorthy(information dynamic)

select sal,rank()over (order by sal desc) from emp where
rownum < = 3;

Answer / nitesh

select sal from emp e where 3>=(select count(distinct sal)
from emp where sal>e.sal) order by sal desc;

Answer / akki julak

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

Answer / swapnareddy

select sal from emp a where 3>(select
count(distinct(sal))from emp b where a.sal<b.sal);

How do you retrieve the last N records from a table?

10 Answers  

what is sql server agent? : Sql dba

0 Answers  

wht is the difference between truncat,drop in sqlserver wht is the difference between function and stored procedure

3 Answers   Apollo,

Explain the update statement in sql

0 Answers  

what are the forced views

6 Answers   Hexaware, TCS,

What is Function based Index and which type of function we can use in Function base index. can we use aggregate,NVL function in Function based Index..

1 Answers   Metric Stream, Polaris,

Difference between truncate, delete and drop commands?

0 Answers  

What are hotfixes and patches?

0 Answers  

What is extent clause in table space?

1 Answers   TCS,

How many sql core licenses do I need?

0 Answers  

How do you retrieve set of records from database server. {Set max records = 100 & use paging where pager page no or records = 10 & after displaying 100 records again connect to database retrieve next 100 }

2 Answers   DELL,

What is duration in sql profiler trace?

0 Answers