通过两列订购MySQL表？
在以下语法的帮助下，将MySQL表按两列排序-
order by yourColumnName1 DESC,yourColumnName2 DESC;
让我们首先为我们的示例创建一个表-
mysql> create table OrderByDemo -> ( -> StudentId int, -> StudentName varchar(100), -> StudentAge int -> );
借助insert命令将记录插入表中。查询如下-
mysql> insert into OrderByDemo values(1,'John',23); mysql> insert into OrderByDemo values(3,'Johnson',24); mysql> insert into OrderByDemo values(4,'Carol',26); mysql> insert into OrderByDemo values(2,'David',20);
现在，将上述语法应用于MySQL表中的两列。查询如下-
mysql> select *from OrderByDemo order by StudentId ASC, StudentAge ASC;
以下是按升序对两列进行排序的输出-
+-----------+-------------+------------+ | StudentId | StudentName | StudentAge | +-----------+-------------+------------+ | 1 | John | 23 | | 2 | David | 20 | | 3 | Johnson | 24 | | 4 | Carol | 26 | +-----------+-------------+------------+ 4 rows in set (0.00 sec)
或者，您可以在DESC命令的帮助下按降序进行操作。查询如下-
mysql> select *from OrderByDemo order by StudentId DESC,StudentAge DESC;
以下是输出-
+-----------+-------------+------------+ | StudentId | StudentName | StudentAge | +-----------+-------------+------------+ | 4 | Carol | 26 | | 3 | Johnson | 24 | | 2 | David | 20 | | 1 | John | 23 | +-----------+-------------+------------+ 4 rows in set (0.00 sec)
注意-主要排序首先起作用。