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
 Other Forums
 Other Topics
 SQLCeServer top 20 ot limit 20,20

Author  Topic 

Koppelstok
Starting Member

3 Posts

Posted - 2004-10-04 : 16:49:24
Hello,

Does someone know how to get the top 20 of a result of a query and getting the next 20 items in SQL CE SERVER

In MySQL I can use limit 20,20 (pos., nbr of rows) is there something like this, also available in SQLCeServer..

Thanks

HansB

robvolk
Most Valuable Yak

15732 Posts

Posted - 2004-10-04 : 21:28:17
Read this article:

http://www.sqlteam.com/item.asp?ItemID=566
Go to Top of Page
   

- Advertisement -