QSQL return multiple rows on a single fetch
Unsolved
General and Desktop
-
Hi,
I am wondering if I can define a number of rows that can be returned on a single fetch when executing queries.
Please see the following for refrence: https://learn.microsoft.com/en-us/sql/odbc/reference/develop-app/rowset-size?view=sql-server-ver16
-
Hi,
You can use the LIMIT clause in your query depending on what you want to achieve. It can help for doing paging.