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

[sarah_thekazekage]

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?

[jasperrocks]

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

[sarah_thekazekage]

This is exactly what I needed. Thanks a lot!

[jasperrocks]

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