首页
学习
活动
专区
工具
TVP
发布
社区首页 >专栏 >SQL基础

SQL基础

原创
作者头像
王脸小
修改2020-08-05 14:32:07
3000
修改2020-08-05 14:32:07
举报
文章被收录于专栏:王漂亮王漂亮

IN, BETWEEN, SUM, DISTINCT, ORDER BY, LIKE

SELECT name, population FROM world

WHERE name IN ('Sweden', 'Norway', 'Denmark')

SELECT name, area FROM world

WHERE area BETWEEN 200000 AND 250000

SELECT SUM(population) FROM world

SELECT DISTINCT region FROM bbc ORDER BY population DESC

SELECT * FROM goal

WHERE player LIKE '%Bender'

SELECT in SELECT

SELECT name FROM world

WHERE population >

(SELECT population FROM world WHERE name='Romania')

JOIN

SELECT *

FROM game JOIN goal ON id=matchid

SELECT a.company, a.num, a.stop, b.stop

FROM route a JOIN route b ON

(a.company=b.company AND a.num=b.num)

WHERE a.stop=53

原创声明:本文系作者授权腾讯云开发者社区发表,未经许可,不得转载。

如有侵权,请联系 cloudcommunity@tencent.com 删除。

原创声明:本文系作者授权腾讯云开发者社区发表,未经许可,不得转载。

如有侵权,请联系 cloudcommunity@tencent.com 删除。

评论
登录后参与评论
0 条评论
热度
最新
推荐阅读
目录
  • IN, BETWEEN, SUM, DISTINCT, ORDER BY, LIKE
  • SELECT in SELECT
  • JOIN
领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档