How do I limit the number of records that will show up in a report?
Posted on June 13, 2018 at 4:09am
I've selected a complete table from the database, I'm using a table element to view the records in the database table.
However, I don't want all the records to show up. I want them to be limited to a certain number, such as 40, regardless of their location (they could be the first 40 rows, for example).
How do I accomplish that?
Joined: Jun 9 2018 - 5:17am
Last seen: 3 years 1 month ago
Posted on June 14, 2018 at 9:15am
If you are using oracle you can use fetch first 40 rows only clause at the end of the query;
If SQL Server TOP 40 clause
If MYSQL limit 40 clause
Joined: Mar 3 2016 - 4:50pm
Last seen: 2 years 9 months ago
If you are using oracle you can use fetch first 40 rows only clause at the end of the query;
If SQL Server TOP 40 clause
If MYSQL limit 40 clause
This is exactly what I needed. Thanks a lot!