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:
SELECT * FROM c_bpartner FETCH FIRST 10 ROWS ONLY
The above command ensure that the command works as you want inside iDempiere.