Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 SELECTing Records# 50-60

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-03-22 : 00:31:30
Ryan writes "Hi,

I checked through your site and couldn't find a decent answer to my problem.

There must be a function in SQL Server 2k that allows the same functionality of MySQL's "LIMIT 50, 60" range-type selector for getting results 50-60 on a particular query, so users can page through possibly hundreds of results.

You guys posted a subquery solution... this seems like such a crappy short-term shortcut; no offense. I've searched through M$'s online SQL Server 2k documentation and haven't found it yet. Are they just stupid?"
   

- Advertisement -