数据库-排序-升降序-多列

排序

根据某个字段进行排序（关键词：ORDER BY ）

mysql> SELECT name, birth FROM pet ORDER BY birth;
+‐‐‐‐‐‐‐‐‐‐+‐‐‐‐‐‐‐‐‐‐‐‐+
| name | birth |
+‐‐‐‐‐‐‐‐‐‐+‐‐‐‐‐‐‐‐‐‐‐‐+
| Buffy | 1989‐05‐13 |
| Bowser | 1989‐08‐31 |
| Fang | 1990‐08‐27 |
| Fluffy | 1993‐02‐04 |
| Claws | 1994‐03‐17 |
| Slim | 1996‐04‐29 |
| Whistler | 1997‐12‐09 |
| Chirpy | 1998‐09‐11 |
| Puffball | 1999‐03‐30 |
+‐‐‐‐‐‐‐‐‐‐+‐‐‐‐‐‐‐‐‐‐‐‐+

升降序排列（desc：降序；asc：升序）

mysql> SELECT name, birth FROM pet ORDER BY birth desc;//降序排列 
mysql> SELECT name, birth FROM pet ORDER BY birth asc ;//升序排列

多列排序

根据species字段升序排列，根据birth字段降序排列

注： ORDER BY species 中无asc，desc，默认为升序排列 

mysql> SELECT name, birth FROM pet ORDER BY birth; 
+‐‐‐‐‐‐‐‐‐‐+‐‐‐‐‐‐‐‐‐‐‐‐+ 
| name | birth | 
+‐‐‐‐‐‐‐‐‐‐+‐‐‐‐‐‐‐‐‐‐‐‐+ 
| Buffy | 1989‐05‐13 | 
| Bowser | 1989‐08‐31 | 
| Fang | 1990‐08‐27 | 
| Fluffy | 1993‐02‐04 | 
| Claws | 1994‐03‐17 | 
| Slim | 1996‐04‐29 | 
| Whistler | 1997‐12‐09 | 
| Chirpy | 1998‐09‐11 | 
| Puffball | 1999‐03‐30 | 
+‐‐‐‐‐‐‐‐‐‐+‐‐‐‐‐‐‐‐‐‐‐‐+