SQL基础语句

检索

单列检索：

SELECT colomn_name

FROM Table_name;

多列检索：

SELECT colomn_name1, colomn_name2,colomn_name3

FROM Table_name;

检索所有列：

SELECT *

FROM Table_name;

---

排序

单列排序：

SELECT colomn_name

FROM Table_name

ORDER BY colomn_name;

多列排序：

SELECT colomn_name1, colomn_name2,colomn_name3

FROM Table_name

ORDER BY colomn_name1, colomn_name2; （优先级：colomn_name1 > colomn_name2)

升降序排序：
ASC(升序，默认)，DESC(降序)

SELECT colomn_name1, colomn_name2,colomn_name3

FROM Table_name

ORDER BY colomn_name1 DESC;

SELECT colomn_name1, colomn_name2,colomn_name3

FROM Table_name

ORDER BY colomn_name1 DESC, colomn_name2;

(优先级：colomn_name1 DESC > colomn_name)