Re: Syntax to return first record - Oracle ??

hi jason,

you could write ...

select min(changedatetime) from tab1

or ...

select max(changedatetime) from tab1

pol.

In article <8ebsfv$86l$1_at_trinitech.demon.co.uk>,   "jason" <jfielding_at_trinitech.co.uk> wrote:
> Hi,
> Could anyone tell me how (and if it's possible) to create a SQL query
 that
> returns only the first (or last) record. Through Access, I could
 write :
>
> select top 1 changedatetime
> from tab1
> order by changedatetime;
>
> Is there an equivelant key word to 'top' (or 'bottom') when using
 standard
> SQL ?
> TIA
> Jason
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Apr 28 2000 - 00:00:00 CEST