The ORDER BY statement in SQL is used to sort the fetched data in either ascending or descending according to one or more columns.
If no keyword is specified after the column based on which we have to sort the records, in that case, the sorting will be done by default in ascending order.
By default ORDER BY sorts the data in ascending order. We can use the keyword the keyword ASC to sort in ascending order.
Syntax to sort the records in ascending order:
SELECT ColumnName1,...,ColumnNameN FROM TableName ORDER BY ColumnName ASC;
or
SELECT ColumnName1,...,ColumnNameN FROM TableName ORDER BY ColumnName;
On this page of the site you can watch the video online SQL LESSON: SQL ORDER BY COMMAND | sort ascending with a duration of hours minute second in good quality, which was uploaded by the user Lecture Hub Ke 18 April 2023, share the link with friends and acquaintances, this video has already been watched 136 times on youtube and it was liked by 1 viewers. Enjoy your viewing!