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)
 Limiting the number of results to a range

Author  Topic 

overbored
Starting Member

12 Posts

Posted - 2002-07-13 : 20:35:04
I'm new to SQL and I'm wondering: how does a search engine limit the number of results returned to a certain range (i.e., the 11th through 20th matches)? Surely it doesn't SELECT everything that matches; there could be potentially millions of matches.

VyasKN
SQL Server MVP & SQLTeam MVY

313 Posts

Posted - 2002-07-13 : 20:37:11
Search this site for the keyword: "Paging"

--
HTH,
Vyas
http://vyaskn.tripod.com
Go to Top of Page

overbored
Starting Member

12 Posts

Posted - 2002-07-13 : 21:09:00
Thanks.

Go to Top of Page
   

- Advertisement -