Closed SingingBush closed 1 year ago
SQLite:
SELECT * FROM users [ ORDER BY ... ] LIMIT 4,3 -- offset is optional so could do LIMIT 4
Postgres:
SELECT * FROM users [ ORDER BY ... ] [ LIMIT { number | ALL } ] [ OFFSET number ]
MS SQL Server:
SELECT * FROM users [ ORDER BY ... ] OFFSET 2 ROWS FETCH 5 ROWS -- can also do SELECT TOP n * FROM...
done
SQLite:
Postgres:
MS SQL Server: