1.分页
mysql: limit 0,10
postgresql: limit 10 offset 0
mssql:
例子:
mysql: SELECT * FROM tc_user WHERE ... ORDER BY ... DESC LIMIT 0,10
postgresql:SELECT * FROM tc_user WHERE ... ORDER BY ... DESC LIMIT 10 offset 0
mssql:
1.分页
mysql: limit 0,10
postgresql: limit 10 offset 0
mssql:
例子:
mysql: SELECT * FROM tc_user WHERE ... ORDER BY ... DESC LIMIT 0,10
postgresql:SELECT * FROM tc_user WHERE ... ORDER BY ... DESC LIMIT 10 offset 0
mssql: