this may help:
http://www.oracle.com/oramag/code/cod01308.html
kev <kevin.porter_at_fast.no> wrote in message
news:37D4DCE7.F831494A_at_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,
>
> - Kev
>
Received on Tue Sep 07 1999 - 10:30:07 CDT
