Search found 1 match
- Sun Apr 23, 2006 8:44 am
- Forum: Databases
- Topic: Pagination with mssql
- Replies: 0
- Views: 523
Pagination with mssql
Hi all, I have a problem. I would like to do a pagination with mssql(SQL SERVER), I know in Mysql I can use limit and in SQL server I can use Top. But I use more table Hom I can do? The query in SQL SERVER : SELECT * TOP 5 from( SELECT * TOP 5 from( SELECT * from table1 order by name_field asc ) as ...