通过两列订购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)
注意-主要排序首先起作用。
热门推荐
10 儿子立冬祝福语简短独特
11 对当兵的祝福语简短
12 侄儿高考试祝福语简短
13 伴郎红包祝福语朋友简短
14 媳妇生日简短祝福语朋友
15 公司年会祝福语简短最好
16 元旦感恩祝福语简短大全
17 红包祝福语简短10字
18 周六早晨祝福语简短