WEB DEVELOPER SITE
HTMLCSSJAVASCRIPTSQLPHPBOOTSTRAPJQUERYANGULARXML
 

SQL LAST() Function


The LAST() Function

The LAST() work restores the last estimation of the chose column.

SQL LAST() Syntax

SELECT LAST(column_name) FROM table_name;

Note: The LAST() work is just bolstered in MS Access.


SQL LAST() Workaround in SQL Server, MySQL and Oracle

SQL Server Syntax

SELECT TOP 1 column_name FROM table_name
ORDER BY column_name DESC;

Example

SELECT TOP 1 CustomerName FROM Customers
ORDER BY CustomerID DESC;

MySQL Syntax

SELECT column_name FROM table_name
Request BY column_name DESC
LIMIT 1;

Example

SELECT CustomerName FROM Customers
ORDER BY CustomerID DESC
LIMIT 1;

Oracle Syntax

SELECT column_name FROM table_name
ORDER BY column_name DESC
WHERE ROWNUM <=1;

Example

SELECT CustomerName FROM Customers
ORDER BY CustomerID DESC
WHERE ROWNUM <=1;

Database

In this instructional exercise we will utilize the database.

Below is a determination from the "Clients" table:

CustomerID CustomerName Phone Address City Country
1

Ramonita Homan 231-596-2048 ORubaiyat Road Stupendous Rapid MI USA
2 Charles L. Emmons 507-256-8113 Rosewood Court Clarks Grove MN USA
3 Ruth C. Dorsey 079 1763 2524 Quay Street NAILBRIDGE YO4 5SS UK
4

Evelyn B. Blacker 077 6011 6540 Wade Lane SAND HOLE YO4 5SS UK
5 Nytorpsv채gen 45 Christina Berglund Nytorpsv채gen 45 BANKERYD Sweden

SQL LAST() Example

The following SQL proclamation chooses the last estimation of the "CustomerName" segment from the "Clients" table:

Example

SELECT LAST(CustomerName) AS LastCustomer FROM Customers;