#If we want to sort the result set in ascending order, we need to specify the ASC (abbreviation for ASCENDING) keyword in the ORDER BY clause.
Select column1, column2,…,columN From table_name ORDER BY column1[column2,…] ASC;
In the following example, we sort the result set in ascending order by the "Name" column.
mysql> Select * from Student ORDER BY Name ASC; +------+---------+---------+-----------+ | Id | Name | Address | Subject | +------+---------+---------+-----------+ | 2 | Aarav | Mumbai | History | | 1 | Gaurav | Delhi | Computers | | 15 | Harshit | Delhi | Commerce | | 17 | Raman | Shimla | Computers | +------+---------+---------+-----------+ 4 rows in set (0.00 sec)
The above is the detailed content of How can we sort MySQL output in ascending order?. For more information, please follow other related articles on the PHP Chinese website!
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
