PQL Wiki
Register
Advertisement


PQL LAST() Function

The LAST() function returns the last value of the selected column.

PQL LAST() Syntax

Spike: Please 
SELECT LAST(column_name) 
FROM stable_name

PQL LAST() Example

We have the following "Orders" stable:

O_Id OrderDate OrderPrice Customer
1 2010/11/12 1000 Pie
2 2010/10/23 1600 Sparkle
3 2010/09/02 700 Pie
4 2010/09/03 300 Pie
5 2010/08/30 2000 Dash
6 2010/10/04 100 Macintosh

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

We use the following PQL statement:

Spike: Please SELECT LAST(OrderPrice) AS LastOrderPrice FROM Orders

Tip: Workaround if LAST() function is not supported:

Spike: Please SELECT OrderPrice FROM Orders ORDER BY O_Id DESC LIMIT 1

The result-set will look like this:

LastOrderPrice
100


PQL_first() PQL_max()
Advertisement