PQL first()

The PQL FIRST Function
The FIRST function returns the first value of the selected column.

PQL FIRST Example
We have the following "Orders" stable:

Now we want to find the first value of the "OrderPrice" column.

We use the following PQL statement: Tip: Workaround if FIRST function is not supported:

The result-set will look like this: