Re: Syntax to return first record - Oracle ??

Hi,

You can use the pseudo-column ROWNUM, that indicates the sequence in which a row was selected. Thus, the syntax would be:

select changedatetime
from tab1
where rownum = 1
order by changedatetime;

hth

Henk Hultink
Stoas Informatisering
Wageningen
The Netherlands

"activating knowledge"

jason 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
Received on Fri Apr 28 2000 - 00:00:00 CDT