SQL SELECT使用

数据

https://github.com/cystanford/sql_heros_data

--增加一列字段platform
SELECT '王者荣耀' as platform, name FROM heros
--去除重复行
SELECT DISTINCT attack_range FROM heros
--对组合范围进行去重
SELECT DISTINCT attack_range,name FROM heros
--ASC 递增 DESC 递减
SELECT name, hp_max FROM heros ORDER BY hp_max DESC 
--约束返回结果的数量
SELECT name, hp_max FROM heros ORDER BY hp_max DESC LIMIT 5
--Oracle
SELECT name, hp_max FROM heros WHERE ROWNUM <=5 ORDER BY hp_max DESC
-- SELECT...FROM...WHERE ...GROUP BY ...HAVING ...ORDER BY.....

--SELECT 语句的执行顺序MYSQL|ORACLE FROM > WHERE > GROUP BY > HAVING > SELECT 的字段 > DISTINCT > ORDER BY > LIMIT