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() |