VB中SQL分頁查詢TOP語句的寫法

另外壹種是拼湊SQL語句，按照妳的描述，應該是傾向於拼湊SQL語句:

Dim PageSize as interger

Dim CurPage as interger

Dim mySql;

MyStr = "Select top " & PageSize & " * from Employees where id not in (select top " & PageSize & " *(" & CurPage & "-1) id from Employees order by id) order by id"

然後調用執行就可以了