MySQL:
Select * from Table order by PrimaryKey DESC LIMIT 0, 3
Daniel
At 23:25 13/8/2001 -0700, you wrote:
>
>Perhaps a:
>
>SELECT TOP 3 PrimaryKey FROM YourTable
>ORDER BY PrimaryKey DESC
>
>(Access/MS SQL only I think.. pretty ignorant of the Oracle quirks)
>
>
>> Use your order by descending:
>>
>> Select * from table_name order by primary_key DESC
>>
>> HTH
>> Hatton
>>
>> -----Original Message-----
>> From: Michael Wilson [mailto:[EMAIL PROTECTED]]
>> Sent: Tuesday, August 14, 2001 12:59 AM
>> To: CF-Talk
>> Subject: getting last 3 records...
>>
>>
>> Hi,
>>
>> I need to get the last 3 (newest) records entered into my table. I know
>how
>> to get the absolute lat record and I know how to get a specific set of
>rows
>> with startrow and maxrows, but I am having trouble getting the last _3_
>> records. Any advice will be much appreciated.
>>
>> Mike
>>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
