Home » SQL & PL/SQL » SQL & PL/SQL » select distinct top 5 sal
select distinct top 5 sal [message #193782] Tue, 19 September 2006 06:59 Go to next message
oracle_coorgi
Messages: 185
Registered: September 2006
Location: INDIA-karnataka
Senior Member
hi

select distinct top 5 sal

thanxs
Re: select distinct top 5 sal [message #193786 is a reply to message #193782] Tue, 19 September 2006 07:11 Go to previous messageGo to next message
sandeepk7
Messages: 137
Registered: September 2006
Senior Member

Select sal
From
(
Select sal, dense_rank() over (order by sal desc) rnk
From emp
)
Where rnk <= 5;



Sandy
Re: select distinct top 5 sal [message #193787 is a reply to message #193782] Tue, 19 September 2006 07:13 Go to previous message
dhananjay
Messages: 635
Registered: March 2002
Location: Mumbai
Senior Member
hi,


 search this forum for your requirement you will get lots of replies.




regards,
Previous Topic: Date format
Next Topic: How to pass the error ?
Goto Forum:
  


Current Time: Mon Dec 05 03:05:45 CST 2016

Total time taken to generate the page: 0.09685 seconds