SQLZOO - SELF JOIN 第十题

最新推荐文章于 2022-07-30 20:22:46 发布

touteng_code

最新推荐文章于 2022-07-30 20:22:46 发布

阅读量881

点赞数 1

文章标签： SQLZOO SELF JOIN

本文链接：https://blog.csdn.net/u013078409/article/details/103217493

版权

该博客探讨了如何使用SQLZOO中的SELF JOIN解决复杂问题，特别是找出从Craiglockhart到Lochend涉及两班车的路线。内容包括查询需求，即显示首班车的车牌号、公司、转乘站名称以及第二班车的车牌号和公司。由于不允许创建视图，解决方案是一条复杂的SQL查询语句。

摘要由CSDN通过智能技术生成

题目：
*Find the routes involving two buses that can go from Craiglockhart to Lochend.
Show the bus no. and company for the first bus, the name of the stop for the transfer,
and the bus no. and company for the second bus.

第十题真的很复杂。先开始想着建立一个视图，逻辑更清晰一些，但是不允许。只能写成一条，如下:



SELECT DISTINCT v1.num,v1.company, name,v2.num,v2.company
// 找出经过Craiglockhart的车辆和其途径的其它站点集合v1(num,company,stop)
FROM 
(

最低0.47元/天解锁文章

确定要放弃本次机会？

福利倒计时

: :

立减 ¥

普通VIP年卡可用

立即使用

touteng_code

关注关注

1
点赞
踩
2

收藏

觉得还不错? 一键收藏
4
评论
复制链接

分享到 QQ

分享到新浪微博

扫一扫

SQLZOO Self join 第十题，这里留下了我的尸体

weixin_44751370的博客

10-09

1318

SQLZOO Self join10.Find the routes involving two buses that can go from Craiglockhart to Lochend.Show the bus no. and company for the first bus, the name of the stop for the transfer,and the bus no. a...

SQLZOO刷题遇到的困难

xiashuying5283的博客

03-11

344

SQLZOO上的难题 sqlzoo难题——self join第十题 Find the routes involving two buses that can go from Craiglockhart to Lochend. Show the bus no. and company for the first bus, the name of the stop for the transfer, and the bus no. and company for the second bus. Hint:Sel

4 条评论您还未登录，请先登录后发表或查看评论

sqlzoo的self join（自联结）最后一题/第十题，未使用子查询的方法

sinat_34839063的博客

05-25

465

在学习sql过程中，在自联结最后一题遇到了困难，阅读许多高手的答案之后，并结合自己的理解整理出以下两种代码（因为不大喜欢子查询的方法，因此没有用该种方法），代码如有不足，欢迎讨论第一种：` SELECT DISTINCT a.num, a.company, stopc.name , c.num, c.company FROM route a JOIN route b ON (a.company = b.company AND a.num = b.num) JOIN ( route c JOIN route

SQLZOO - Self join 第十题（最后一题）

weixin_49054507的博客

03-05

245

SQLZOO - Self join 第十题（最后一题）保证正确的答案~一开始网上找到的答案都不对，自己又思考了一下做出来啦！ Find the routes involving two buses that can go from Craiglockhart to Sighthill. Show the bus no. and company for the first bus, the name of the stop for the transfer, and the bus no. and com

SQLZOO-selfjoin

fog_435的博客

08-17

244

题目：Find the routes involving two buses that can go from Craiglockhart to Lochend. Show the bus no. and company for the first bus, the name of the stop for the transfer, and the bus no. and company for the second bus. 表1： stops Value id name 表

Self join-SQLZOO-10

hejnhong的博客

06-10

285

题目 Find the routes involving two buses that can go from Craiglockhart to Lochend. Show the bus no. and company for the first bus, the name of the stop for the transfer, and the bus no. and company for the second bus. 查找从Craiglockhart到Lochend，需要换乘一次的公交路线，也就

SQLZOO——Self join（难难难）

Deng_Allen的博客

01-20

339

1.How manystopsare in the database. SELECT COUNT(id) FROM stops -- 直接计数即可 2.Find theidvalue for the stop 'Craiglockhart'. SELECT id FROM stops WHERE name = 'Craiglockhart'

SQLZOO练习题答案参考（全）

m0_50871079的博客

07-30

3217

自学SQL将近一年，比较有名的SQL题库都尝试刷过，一边刷高阶题，一边会回头复盘，尝试多种解法，因此不定时分享刷过的题库的参考解法，第一篇是SQL_ZOO

SQLZOO SELF JOIN

bestallen的博客

01-13

3046

1: How many stops are in the database SELECT COUNT(*) FROM stops 2:Find the id value for the stop 'Craiglockhart' SELECT id FROM stops WHERE name = 'Craiglockhart' 3:Give the id and the

MySQL练习9

Hielw的博客

05-02

964

来源于zoo sql，联系表自连接操作表结构图如下：stops表，id为站点序号，name为站点名字route为线路表：num为线路序号，表示公交车顶上的线路，如13路公交车，num就为13，company为运作该线路的公司名字，pos为顺序，stop为站点编号，关联stops表的id字段重点看route表，部分数据如下：1路公交车，第1个站点为137，第2个站点为99，依次类推练习题目：1. H...

sqlzoo第九部分错题及答案

harveyzz的博客

07-30

475

stops(id, name) route(num, company, pos, stop) 3.Give the id and the name for the stops on the ‘4’ ‘LRT’ service select id,name from stops join route on route.stop=stops.id where num=4 and company='LRT'#有错误，但我自己找不到，想哭# 8.Give a list of the services which

SQLZOO部分题目解析【后续更新】

斯瑞德想要进步

07-19

7848

SQLZOO（https://sqlzoo.net/wiki/SQL_Tutorial）是一个SQL语句编写练习网站，题量较多，涉及的范围相对全面，作为巩固基础语句的练习也是不错的选择。虽然网页中不少为基础练习，但是也有部分题目对我来说是需要多花点时间的，特地在这篇文章内记录下来以备后续参考。

SQL ZOO练习——Self join

一个好学生_叶纪杉

08-10

871

1. How many stops are in the database. SELECT COUNT(*) FROM stops 2. Find the id value for the stop 'Craiglockhart' SELECT id FROM stops WHERE name = 'Craiglockhart' 3. Give the id and the name...

sqlzoo练习答案--Self join

非淡泊无以明志，非宁静无以致远

08-07

884

stops(id, name) route(num,company,pos, stop) stops route id num name company pos stop 1、How many stops are in the database.

Self join

Deby_zd的博客

09-12

1245

Self join

sqlzoo self join 最后一题

zxn1996csdn的博客

03-27

323

原题： Find the routes involving two buses that can go from Craiglockhart to Lochend. Show the bus no. and company for the first bus, the name of the stop for the transfer, and the bus no. and company fo...

sqlzoo习题答案--Self join

codema的博客

06-28

1001

Details of the database Looking at the dataDetails of the database Looking at the datastops(id, name) route(num,company,pos, stop) stopsrouteidnumnamecompany pos stop

sql self join