Re: To display 5 Largest values from table

> i want to display first 3 persons with largest salary

select * from
  (select tbl.*, rank() over(order by salary desc) r from tbl ) where r <=5;

hth
Rene Nyffenegger

-- 
  Projektleitung und Entwicklung in Oracle/C++/C# Projekten
  http://www.adp-gmbh.ch/cv.html