sql Q&N

SQL题目记录

---

---

1-3

---

0. SQL语句执行顺序

1. FROM
2. JOIN
3. ON
4. WHERE
5. GROUP BY
6. 聚集函数(AVG, MIN, MAX, SUM, COUNT)
7. HAVING
8. 表达式(JOB/DEPTNO)
9. SELECT
10. DISTINCT
11. ORDER BY
    以上每个步骤都会产生一个虚拟表，该虚拟表被用作下一个步骤的输入。

1. 在下面的例子中，展示了语句筛选中还要看看数据长什么样子。确保只有Island（有些数据是：Islands）

SELECT name FROM countries_regions WHERE name LIKE "%Island%" AND name NOT LIKE "%Islands%";

2. SELECT 中AS后面的定义newName的不可以在筛选条件中使用

SELECT population/area AS density, distince name FROM countries_regions WHERE population > 10000000 ORDER BY population/area DESC LIMIT 5;

3. 后有GROUP BY，前不加DISTINCT; DISTINCT只可以写在SELECT 后面/括号里

SELECT DISTINCT name FROM countries_regions;
SELECT continent, COUNT(DISTINCT name) FROM countries_regions;

---