How to limit rows in Progress SQL SELECT

Question

What's the equivalent to SQL Server's TOP or DB2's FETCH FIRST or mySQL's LIMIT in Progress SQL?

Answer 1

You can use LIMIT just like in MySQL, for example:

SELECT * FROM users LIMIT 5;

Answer 2

Use the LIMIT clause.