sqlzoo
关注
分享
扫一扫
Sweeney Chen
厚积薄发！
展开
专栏收录文章
- 默认排序
- 最新发布
- 最早发布
- 最多阅读
- 最少阅读
-
sqlzoo--select basics,select from world
sqlzoo(1)world表格:namecontinentareapopulationgdpAfghanistanAsia6522302550010020343000000AlbaniaEurope28748283174112960000000AlgeriaAfrica238174137100000188681000000A...原创 2019-07-20 12:12:24 · 431 阅读 · 0 评论 -
sqlzoo--select from nobel ,select in select
sqlzoo(2)select from nobel 字段：yr（年份）,subject（奖项）,winner（获奖者）yrsubjectwinner1960ChemistryWillard F. Libby1960LiteratureSaint-John Perse1960MedicineSir Frank Macfarlane Burnet...原创 2019-07-21 15:06:25 · 770 阅读 · 0 评论 -
sqlzoo--More JOIN operations
More JOIN operationsmovie电影（id编号,title电影名称,yr首映年份,director导演,budget预算,gross票房)actor(id编号,name姓名)casting(movieid电影编号,actorid演员编号,ord角色次序)列出1962年首映的电影，显示其id,titleSELECT id,title FROM movie WHE...原创 2019-08-25 14:56:06 · 561 阅读 · 0 评论 -
sqlzoo--sum and count
SUM and COUNTnamecontinentareapopulationgdpAfghanistanAsia6522302550010020343000000AlbaniaEurope28748283174112960000000AlgeriaAfrica238174137100000188681000000Andorr...原创 2019-08-27 00:00:30 · 520 阅读 · 0 评论 -
sqlzoo--the join operation
The JOIN operationTABLE game:id(編號)mdate(日期)stadium(場館)team1(隊伍1)team2(隊伍2)10018 June 2012National Stadium, WarsawPOLGRE10028 June 2012Stadion Miejski (Wroclaw)RUSCZE1003...原创 2019-09-02 18:58:56 · 552 阅读 · 0 评论 -
sqlzoo--using null
sqlzoo–using nulltable:teacher教师id編號dept學系name名字phone內線電話mobile流動電話1011Shrivell275307986 555 12341021Throd275407122 555 19201031Splint2293104Spiregrain328710...原创 2019-09-16 22:00:47 · 566 阅读 · 0 评论 -
sqlzoo--self join
sqlzoo–self join已有字段：table:stopstable:routeidnumnamecompanyposstop数据库中有多少个站点select count(id) from stops;找出车站‘craiglockhart’的idselect id from stopswhere name = ...原创 2019-09-18 20:03:02 · 777 阅读 · 0 评论