You can do successive finds e.g. get top 300, order by the reverse of your original pull then do top 100 on that recordset. This, of course, assumes that you don't have a unique row identifier to do a select where id between 200 and 300. For example:
SELECT TOP 100 t1.* FROM (SELECT TOP 300 nonLinearId, fName, lName FROM myTable ORDER BY lName DESC) t1 ORDER BY t1.lName ASC Lori wrote: >Like starting from 200 and going to 300. >~Lori >----- Original Message ----- >From: "Eric Creese" <[EMAIL PROTECTED]> >To: "CF-Talk" <[email protected]> >Sent: Tuesday, January 18, 2005 1:54 PM >Subject: RE: MySql to Sql Server Convert LIMIT > > > > >>LIMIT like the number of records you return???? If so SQL server has TOP >> >> >[number of records]. Not sure if that is what you are looking for? > > >>-----Original Message----- >>From: Lori [mailto:[EMAIL PROTECTED] >>Sent: Tuesday, January 18, 2005 12:51 PM >>To: CF-Talk >>Subject: MySql to Sql Server Convert LIMIT >> >> >>Anyone have any ideas of the best way to do a LIMIT in Sql Server? I know >>sql server does not have an equivalant. I have an idea of what I want to >> >> >do > > >>but wanted to get other ideas too. >> >>~Lori >> >> >> >> >> >> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware: a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190974 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
