Call me silly - but Oracle doesn't support it, does it?
I know I've always used :
select PuddingName
from PuddingTable
where rownum < 2
order by PuddingID desc
to get the top 2 rows
Brian
-----Original Message-----
From: Matthew Walker [mailto:[EMAIL PROTECTED]]
Sent: Sunday, December 10, 2000 9:11 PM
To: CF-Talk
Subject: RE: Getting last 2 records
> but what is 'PuddingID'? :-)
All puddings must be identified uniquely!
> There are a bunch of databases out there not 'really' sql92 compatibles.
> So it really depends...
Are there many that don't support TOP?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
