Return large query result sets

Apply OS: Windows, macOS, Linux

Apply Navicat Product: Navicat for MySQL, Navicat for PostgreSQL, Navicat for SQLite, Navicat for MariaDB, Navicat Premium

Apply Navicat Version No.: All

We suggest you to limit your query results each time. You can use the LIMIT clause to accomplish it. The LIMIT clause can be used to constrain the number of rows returned by the SELECT statement.