Just reverse the order like: SELECT TOP 100 * FROM tablename order by something desc
HTH, Howie ----- Original Message ----- From: "Tyler Clendenin" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, June 06, 2002 2:45 PM 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 > > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
