mysql LAST() function

英[lɑ:st] 美[læst]

n.last;end;last;shoe last (model for making shoes)

vt.withstand;after... ; Enough; Sufficient to maintain (especially for a certain period of time)

adj. The last; the latest; the least likely; the only one left

vi. Continue

adv.Last; last time, most recent time

Third person singular: lasts Present participle: lasting Past tense: lasted Past participle: lasted

mysql LAST() function syntax

Function: Returns the value of the last record in the specified field.

Syntax: SELECT LAST(column_name) FROM table_name

Notes: You can use the ORDER BY statement to sort records.

mysql LAST() function example

//查找"OrderPrice" 列的最后一个值
SELECT LAST(OrderPrice) AS LastOrderPrice FROM Orders;