The LAST() returns the last value of the selected column.
Syntax:-
SELECT LAST(column_name) FROM table_name;
OR
SELECT column_name FROM table_name ORDER BY column_name DESC LIMIT 1;
Example:-
The subsequent SQL selects the last value of the “VisitorName” column from the “Visitors” table:-

SELECT LAST(VisitorName) AS LastVisitor FROM Visitors;
OR
SELECT VisitorName FROM Visitors ORDER BY VisitorID DESC LIMIT 1;

Categories: SQL Function

0 thoughts on “SQL Last()”

Leave a Reply