How do I limit the number of records that will show up in a report?

0

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?

sarah_thekazekage's picture
Joined: Jun 9 2018 - 5:17am
Last seen: 1 year 5 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

jasperrocks - 1 year 5 months ago

This is exactly what I needed. Thanks a lot!

sarah_thekazekage - 1 year 5 months ago

1 Answer:

1

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

 

jasperrocks's picture
Joined: Mar 3 2016 - 4:50pm
Last seen: 1 year 1 month ago
Feedback