MS SQL is a popular database from Microsoft.  There are subtle nuances in the syntax between MS SQL Server than PostgreSQL. One of these differences is limiting the result set.  In MS SQL, we use the following:

SELECT TOP 10 *   FROM c_bpartner

However, in PostgreSQL, we use the following to limit the result set:

SELECT  *  FROM c_bpartner LIMIT 10

If we use LIMIT inside iDempiere via the Application Dictionary, this will fail.    iDempiere was originally created for Oracle. Although a SQL mapping exists between the Oracle and PostgreSQL syntax, this is not effective for the LIMIT statement.  The SQL command to use in the Application Dictionary should be the following:


The above command ensure that the command works as you want inside iDempiere.