Return records 5 thru 10

dmorand

I realize that mySQL uses the Limit 5,10 type functionality, but I need to retrieve only records 5 thru 10 in my query.

I'm assuming I need to use TOP....

I can do something like this, but I am not going to certainly get the records I need.
SELECT TOP 5 from TABLE order by FIELD DESC

I'm doing this to create some pagination on my web application search results.

balame2004

Hey, Try this.

Select Top 5 from Table where Field In(select Top 10 Field from Table order by Field) order by Field Desc

dmorand

Thanks that'll do the trick!

Return records 5 thru 10

re: Return records 5 thru 10

re: Return records 5 thru 10

Similar Microsoft SQL Server bytes

/bytes/development

/bytes/it

/bytes/about