Patch Number

Ticket Number

Change Type

PN5_20455

XXXXXX

Enhancement

1. Description

Implement SQL SELECT TOP Clause.

The SELECT TOP clause is used to specify the number of records to return and can be very useful on large tables with thousands of records. Returning a large number of records can impact on performance.

Added to help with testing and development on client sites.

Example of new syntax:

SELECT TOP 100 * FROM my_table

1.1. Previous Release Behavior

N/A

1.2. Current Release Behavior

New functionality