How can I do a "select" to only retrieve one row, i.e. limit=1 in SQL

If I only want to retrieve one row from a data set, the equivalent of limit=1 in SQL, do I need to do it by setting page size to 1 and only getting 1 page, or is there a query option to do this ?

Hi Richard!
Using pageSize=1 in query will be correct. More information you can find here: