To select the to Top n rows in oracle SQL select name, price from ( select name, price, row_number() over (order by price) r from items ) where r between 1 and 5; select * from ( select b.systemcode, b.lid , a.STARTDATE, a.EVENTDESCRIPTION from sbyn_encounter a, sbyn_person b where b.LID='204997' and b.SYSTEMCODE='SFH' and a.PERSONID=b.personid and a.startdate is not null order by a.STARTDATE desc ) where rownum <= 1; |
KB >