select top 100 from tablename order by pk DESC the "ORDER BY whatever DESC" is the key
Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -----Original Message----- From: Tyler Clendenin [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 06, 2002 2:46 PM To: CF-Talk Subject: OT: msSQL/t-SQL BOTTOM I know there is a TOP funcion i.e. SELECT TOP 100 * FROM tablename and i have heard there is also a way to get the bottom too, can anyone tell me what this might be. Tyler Clendenin GSL Solutions ______________________________________________________________________ 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists