mysql
"select * from t_name limit 0, 1000"
MSSQL
"select row_number() as rownum, * from t_name where rownum BETWEEN 0 and 1000"
mysql
"select * from t_name limit 3, 1000"
MSSQL
"select row_number() as rownum, * from t_name where rownum BETWEEN 3 and 3+1000"
<< PREV :
[1] : ... [11] : [12] : [13] : [14] : [15] : [16] : [17] : [18] : [19] : ... [139] :
NEXT >>
