MySQL last function

MySQL last function is used to return the last value of the selected column.

Syntax:

snippet

SELECT column_name
FROM table_name
ORDER BY column_name DESC
LIMIT 1;

MySQL last function example

Consider a table "officers" having the following data.

Execute the following query:

snippet

SELECT officer_name 
FROM officers
ORDER BY officer_id DESC
LIMIT 1;

This query will return the last officer_name ordering by officer_id.

Output:

Return the last officer_name ordering by officer_name:

snippet

SELECT officer_name 
FROM officers
ORDER BY officer_name DESC
LIMIT 1;

Output:

Related Tutorial

1 MySQL count() Function

2 MySQL sum() function

3 MySQL avg() function

4 MySQL min() function

5 MySQL max() function

6 MySQL GROUP_CONCAT() Function

7 MySQL first function

8 MySQL last function

Try it

Contents +