Not from what I can remember. The only way I can think of doing it,
assuming that there is no 'logical' key to get the max and min on
would be to do an SP which opens a cursor, returns the first item,
moves to the end, spits out the last one.
The 'logical' key thing would be much better tho!
Or something like that :)
N
[EMAIL PROTECTED] wrote:
>
> Some non-standard dialoects also have a first/last keyword (Transact SQL
> does I thing ... It's been a while since I used Sybase).
>
> "Max Renshaw-Fox" <[EMAIL PROTECTED]> on 17/02/99 14:17:30
>
> Please respond to [EMAIL PROTECTED]
>
> To: Multiple recipients of list delphi <[EMAIL PROTECTED]>
> cc: (bcc: Peter Jones/Logistics&Information
> Technology/Christchurch/Foodstuffs)
> Subject: RE: [DUG]: SQL - The First Shall Be Last...
>
> Try
>
> SELECT * FROM Custoly
> WHERE CustNo = (SELECT MIN(CustNo) FROM Custoly)
> OR CustNo = (SELECT MAX(CustNo) FROM Custoly)
>
> (Where did I get the names from - ...\Demos\Data)
>
> if you want first and last by Primary Key rather than natural order.
>
> Max
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Mark Derricutt
> Sent: Wednesday, 17 February 1999 13:59
> To: Multiple recipients of list delphi
> Subject: [DUG]: SQL - The First Shall Be Last...
>
> Does anyone know if its possible to write an SQL query that returns the
> first and last record in a table???
>
> ---------------------------------------------------------------------------
> New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
>
> ---------------------------------------------------------------------------
> New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
>
> ---------------------------------------------------------------------------
> New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz