but what is 'PuddingID'? :-)
Let's say you are working with a FoxPro table. You may not have an id at
all.
There are a bunch of databases out there not 'really' sql92 compatibles.
So it really depends...
laszlo
Matthew Walker wrote:
>
> > > > What SQL command do I use to obtain the last 2 records in a Table?
>
> The classy way is just to use SQL...
>
> SELECT TOP 2 PuddingName
> FROM Puddings
> ORDER BY PuddingID DESC
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
