Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> selecting _only_ the latest ten items

selecting _only_ the latest ten items

From: kev <kevin.porter_at_fast.no>
Date: Tue, 07 Sep 1999 10:37:43 +0100
Message-ID: <37D4DCE7.F831494A@fast.no> 





Hi,



What's the best way of selecting, say, the latest 10 news stories from a
DB. Do I have to select all the items ordered by date, but just show the
latest ten. Or is there some SQL I can use which will select only the
latest 10 from the DB. It could just as easily be the second, or the
third ten which I want. It's for a website (using PHP) where I want to
show 10 news stories, then if a user clicks the 'more' link, the next 10
are displayed, etc.



TIA,





Received on Tue Sep 07 1999 - 04:37:43 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US