Search found 1 match

by maxxer
Sun Apr 23, 2006 8:44 am
Forum: Databases
Topic: Pagination with mssql
Replies: 0
Views: 522

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 ...