SQL LAST() Function

The LAST() Function

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

SELECT LAST(column_name) FROM table_name

We have the following "Purchases" table:

PU_ID	OrderDate	OrderPrice	Customer
1	2015/11/12	1000	Karmen
2	2015/10/23	1600	Tendulkar
3	2015/09/02	700	Karmen
4	2015/09/03	300	Karmen
5	2015/08/30	2000	Jensen
6	2015/10/04	100	Tendulkar

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

We use the following SQL statement:

SELECT LAST(OrderPrice) AS LastOrderPrice FROM Purchases

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

SELECT OrderPrice FROM Purchases ORDER BY PU_ID DESC LIMIT 1

The result-set will look like this:

LastOrderPrice
100

SQL HOME
SQL Syntax
SQL Select
SQL Distinct
SQL Where
SQL And & Or
SQL Order By
SQL Insert
SQL Update

SQL Functions
SQL avg()
SQL count()
SQL first()
SQL last()
SQL max()
SQL min()
SQL sum()
SQL Group By
SQL Having
SQL ucase()
SQL lcase()
SQL mid()
SQL len()
SQL round()
SQL now()
SQL format()