（六）SQL | 数据查询语言DQL | 基础查询

01  语法

SELECT col_list
FROM tb_name
WHERE condition_list
GROUP BY group_col_list
HAVING after_group_condition_list
ORDER BY order_col_list
LIMIT x, y;

02  基础查询  SELECT ... FROM ...

（1）查询列

SELECT col_1 [AS alias_1], col_2 [AS alias_2], ... FROM tb_name;
SELECT * FROM tb_name;  -- 查询返回所有字段（尽量不要使用*，不直观）

         AS 为列设置别名，AS可省略。别名可设可不设。

（2）去重

SELECT DISTINCT col_list FROM tb_name;

举个例子（MySQL）

        这里采用MySQL自带的 World数据库 中的 countrylanguage表 进行操作，该表结构如下：

countrylanguage表结构

-- 查询所有字段
select * from countrylanguage;
select countrycode as c, language as l, isofficial as i, percentage as p from countrylanguage;

select * from countrylanguage

select countrycode as c, language as l, isofficial as i, percentage as p from countrylanguage;

  

-- 去重
select distinct language from countrylanguage;

select distinct language from countrylanguage;

不总结=白学

---

THE END

---