如何根据多列获得排序后的输出?
mysqlmysqli database
我们可以在 ORDER BY 子句中指定多列，以根据这些多列获得排序后的输出。下面举个例子来更清楚地说明这个概念。 −
mysql> Select * from Student ORDER BY Name, Address; +------+---------+---------+-----------+ | 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.12 sec)
