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
 Transact-SQL (2000)
 Select records between certain ranges.

Author  Topic 

great_mamun
Starting Member

14 Posts

Posted - 2008-08-28 : 07:16:47
Dear All,
My query is, str="select * from Customer order by age limit 10,20";
but limit didn't work in mssql though it worked on mysql.
how do I convert above query into mssql query.

Best Regards,
Abdullah Al Mamun

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2008-08-28 : 07:25:15
Search for Pagination

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -