Search code examples
sqllimitprogress-4glopenedgeprogress-db

LIMIT Result in Progress 10.1C


Is there a way to limit the result of a SQL Query in Progress 10.1C like in MYSQL LIMIT 0, 1000?

Regards


Solution

  • Progress SQL calls it "TOP" i.e.:

    SELECT TOP 5 FROM pub.customer ORDER BY balance DESC;