Re: Getting first/last record

To get the first record from a table -----

select * from emp where rownum<2;

and to get the last record from the query

select * from emp where rowid=(select max(rowid) from emp);

hope this helps..

bye..
Kevin A Lewis wrote in message ...
>does
>
> select to_char(sysdate,'HH24:MI:SS') from dual
>
>Help at all - See your "SQL Language Reference Manual" for more details
>
>--
>Kevin A Lewis (BOCM PAULS LTD - Animal Feed Manufacturer - Ipswich England)
> <KevinALewis_at_HotMail.com>
>
>The views expressed herein by the author of this document
>are not necessarily those of BOCM PAULS Ltd.
>STEVE <spectre_at_hkstar.com> wrote in message
>news:1duzlc6.l8llj89qdonwN@[201.1.1.73]...
>> HI,
>> Thanks for your Quick reply, the only thing that wories me is that the
>> time does not actually show up, is it to second resolution?
>> even if i do a "SELECT SYSDATE FROM DUAL;" it does not show the time.
>> my oracle 8 bible says time is available , but does not go into it.
>>
>> All you book writers pay attention.
>>
>> steve
>>
>>
>> Brian Peasland <peasland_at_email.msn.com> wrote:
>>
>> > >Being a bit of a newbee, to oracle8 can anybody help with the
>following.
>> > >1.How to get the first record in an ordered table
>> > >2 How to get the last record in an ordered table.
>> > >the order being on date then time.
>> >
>> >
>> > The Oracle DATE format stores both the date and the time in one field.
>So
>> > you can just query the date field. Assuming the table is named 'TABLEX'
>and
>> > the date field is labelled 'COLX', try this:
>> >
>> > SELECT min(COLX), max(COLX) from TABLEX;
>> >
>> > Hope that helps,
>> > Brian Peasland
>> > peasland_at_msn.com
>
>
Received on Thu Jul 15 1999 - 08:09:28 CDT