In this topic, we described about the Select Last with detailed example.
SELECT LAST statement used to fetch last value from specified column in existing table. SELECT LAST Statement works only in MS Access database only.
SELECT LAST (Column_name) FROM table_name;
- column_name - Specifies the name of the column on which LAST clause applied.
Syntax for creating user defined name to the required column –
SELECT LAST (column_name) AS user_defined_name FROM table_name;
- user_defined_name- Specifies the name of the output column name in result-set.
Let us consider below table(s) as an example table(s) to frame the SQL query for getting the desired results.
Scenario – Fetch the last value of the required column from table.
Requirement – Fetch last row value of emp_name column in employee_details table.
The query was as follows –
SELECT LAST (emp_name) FROM employee_details;
By executing above query, we can get output like as shown in below –
Scenario – Fetch last value of the required column from table and name the result column with user defined column name.
Requirement – Fetch last row value salary column from employee_details table and name the column as last_salary. The query was as follows –
SELECT LAST (salary) AS last_salary FROM employee_details;
By executing above query,we can get output like as shown in below -