SQL -Structured Query Language - Sql Order By - Ascending Tutorial

To retrieve a record in ascending order from the existing created table. Then we can use an ' ORDER BY ' Clause with ASC Attribute.

Syntax-

The basic syntax of the ORDER BY statement with ASC Attribute is given below –

SELECT * FROM table_name ORDER BY column_name ASC

For example-

SELECT first_name FROM employees ORDER BY first_name ASC;

Run Query

Here it will retrieve all records from the Employees table in ascending order of a first_name column.