Re: selecting 5 most recent records (oracle/sql newbie)

From: Steven Harrod <scharrod_at_earthlink.net>
Date: Thu, 14 Sep 2000 01:17:07 GMT
Message-ID: <nGVv5.1093$JT3.49678@newsread2.prod.itd.earthlink.net>

Mr. Oatmeal,

Do you have to use the input date or can you sort the records by inpute date in descending order and grab the first 5 records.

steve

mr_oatmeal <mr_oatmeal_at_hotmail.com> wrote in message news:ss06tt5fct646_at_corp.supernews.com...
> Hello,
>
> I'm trying to figure out how to select the 5 most recent records (based on
> input_date) from a table...does anyone have a general idea how to do
> this. So if 10 records were input today, i would want to return only the
> most recent 5.
>
> ex_table
>
> record_id
> input_date
>
> Thanks
>
>
> --
> Posted via CNET Help.com
> http://www.help.com/
>
Received on Wed Sep 13 2000 - 20:17:07 CDT