In MySQL, you can use “LIMIT <skip> <count>”, like this:
select * from sometable order by name limit 20,10
In Oracle: https://www.withdata.com/blog/oracle/how-to-limit-the-number-of-rows-returned-by-an-oracle-query-after-ordering.html .
In SQL Server: https://www.withdata.com/blog/sql-server/the-sql-server-equivalent-for-the-mysql-limit.html .
In DB2: https://www.withdata.com/blog/db2/the-db2-equivalent-for-the-mysql-limit.html .
In Sqite: https://www.withdata.com/blog/sqlite/how-to-limit-the-number-of-rows-returned-by-an-sqlite-query.html .
In PostgreSQL: https://www.withdata.com/blog/postgresql/how-to-limit-the-number-of-rows-returned-by-an-postgresql-query.html .
Some MySQL tools you can try: https://www.withdata.com/mysql/
Convert your data online, free
Free in-browser converters for CSV, Excel, JSON, XML and SQL: Withdata Online Data Conversion. Large files, batch conversion or scheduling? See the offline desktop apps, or browse all data conversion tools.