You can limit rows that are returned from a database query on the basis of some limiting value. The **sql:limit-field** and **sql:limit-value** annotations are used to identify the database column ...
--Task 1: Retrieve the first 10 rows from the customers table ordered by customer_name. select * from customers order by customer_name limit 10; --Task 2: Display the top 5 most expensive products ...
With connectors in Power Apps we can collect 2000 items at a time when we read data from lists and libraries. However with SQL Stored Procedures in Power Apps we have an option to avoid this limit!