SQL入门系列
文章平均质量分 74
x___xxxx
这个作者很懒,什么都没留下…
展开
-
【SQL入门系列二】SQLZOO 分组
入门二5 SUM and COUNT5 SUM and COUNTAggregate functionsSUM, COUNT, MAX, AVGSUM//世界总人口SELECT SUM(population)FROM world//Africa的总GDPSELECT SUM(GDP) FROM worldWHERE continent='Africa'DISTINCI去掉SELECT得到的重复项//列出所有洲SELECT DISTINCT(continent)FROM w原创 2020-07-30 11:17:36 · 699 阅读 · 0 评论 -
【SQL入门系列一】SQLZOO-SELECT
0 SELECT basicsWHERESELECT population FROM worldWHERE name = 'Germany'IN list中的多项是否存在SELECT name, population FROM world WHERE name IN ('Sweden', 'Norway', 'Denmark');BETWEEN 范围SELECT name, area FROM world WHERE area BETWEEN 200000 AND 250000.原创 2020-07-25 22:30:41 · 515 阅读 · 0 评论