Order by something desc
the order by sorts it, the something is whatever you use to track when a
record went in and the desc says, sort it from last record first. Then just
limit the CFQUERY to a maxrows of 2.
> Hi,
>
> What SQL command do I use to obtain the last 2 records in a Table?
>
> Rgds
>
> Will
> www.localbounty.com
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
