89

MySQL last function

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

Syntax:

MySQL last function example

Consider a table “officers” having the following data.

Execute the following query:

This query will return the last officer_name ordering by officer_id.

Output:

Return the last officer_name ordering by officer_name:

Output:

---