Syntax to return first record - Oracle ??
From: jason <jfielding_at_trinitech.co.uk>
Date: 2000/04/28
Message-ID: <8ebsfv$86l$1_at_trinitech.demon.co.uk>#1/1
Date: 2000/04/28
Message-ID: <8ebsfv$86l$1_at_trinitech.demon.co.uk>#1/1
Hi,
[Quoted] [Quoted] Could anyone tell me how (and if it's possible) to create a SQL query that
[Quoted] returns only the first (or last) record. Through Access, I could write :
select top 1 changedatetime
from tab1
[Quoted] order by changedatetime;
[Quoted] 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 CEST