Using SQL LAST

SQL LAST: Main Tips

• SQL SELECT LAST function brings back the value of the last data record of the defined column.
• The type it returns is the same as the Scalar.

Syntax of SQL LAST

SELECT LAST(col_name) FROM tbl_name;

Note: SQL SELECT LAST function is only supported in the MS Access. Therefore, the following workarounds have to be used to retrieve the last record in MySQL, Oracle and SQL server.

Workaround in SQL Server, MySQL and Oracle

SQL Server: Syntax

SELECT TOP 1 col_name FROM tbl_name
ORDER BY col_name DESC;

SELECT TOP 1 Name FROM Customers
ORDER BY ID DESC;

Pros

• Easy to use with a learn-by-doing approach
• Offers quality content
• Gamified in-browser coding experience
• The price matches the quality
• Suitable for learners ranging from beginner to advanced

Main Features

• Free certificates of completion
• Focused on data science skills
• Flexible learning timetable

GET 25% OFF

Pros

• Simplistic design (no unnecessary information)
• High-quality courses (even the free ones)
• Variety of features

Main Features

• Nanodegree programs
• Suitable for enterprises
• Paid Certificates of completion

UP TO 70% OFF

Pros

• A wide range of learning programs
• University-level courses
• Easy to navigate
• Verified certificates
• Free learning track available

Main Features

• University-level courses
• Suitable for enterprises
• Verified certificates of completion

FREE COURSES

MySQL: Syntax

SELECT col_name FROM tbl_name
ORDER BY col_name DESC
LIMIT 1;

SELECT Name FROM Customers
ORDER BY ID DESC
LIMIT 1;

Oracle: Syntax

SELECT col_name FROM tbl_name
ORDER BY col_name DESC
WHERE ROWNUM <=1;

SELECT Name FROM Customers
ORDER BY ID DESC
WHERE ROWNUM <=1

Demo Database

In the below table, there is a part of a Customers table:

SQL LAST: Example

In the code example below, we make SQL select last value of the column CustomersName in the table Customer:

SELECT LAST(Name) AS LastCustomerID FROM Customers;