To retrieve a record in ascending order from the existing created table. Then we can use an ' ORDER BY ' Clause with ASC Attribute.
The basic syntax of the ORDER BY statement with ASC Attribute is given below –
SELECT * FROM table_name ORDER BY column_name ASC
SELECT first_name FROM employees ORDER BY first_name ASC;
Here it will retrieve all records from the Employees table in ascending order of a first_name column.
Best learning portal that provides you great learning experience of various technologies with modern compilation tools and technique
Don't hesitate to give us a call or send us a contact form message