- 博客(6)
- 收藏
- 关注
RSS订阅原创 sqlzoo - 9 Self join
@TOG3.Give the id and the name for the stops on the ‘4’ ‘LRT’ service.列出LRT公司4号线公交停靠的站名及站的ID号根据答案推的order by posselect id, name from stops join route on stops.id = route.stop where company = 'LRT' and num = 4 order by pos4. Routes and stopsThe
2020-11-26 19:53:49
400
原创 sqlzoo - 9- Window functions
目录2. * Rank (Who won?)3. * PARTITION BY4. - Edinburgh Constituency5. * Winners Only6. Scottish seats- 代表省略 与前面题型相同* 代表错题，重点看? 代表有疑问2. * Rank (Who won?)You can use the RANK function to see the order of the candidates. If you RANK using (ORDER BY vot
2020-11-22 22:17:26
624
原创 sqlzoo - 8 Using Null & 8+ Numeric Examples / NSS Tutorial
目录5. COALESCE8. The number of staff in each department9. CASE- 代表省略 与前面题型相同* 代表错题，重点看? 代表有疑问5. COALESCEUse COALESCE to print the mobile number. Use the number ‘07986 444 2266’ if there is no number given. Show teacher name and mobile number or ‘0798
2020-11-21 23:58:53
219
原创 sqlzoo - 7 More JOIN operations
目录6. Cast list for Casablanca7. - Alien cast list8. - Harrison Ford movies9. Harrison Ford as a supporting actor10. Lead actors in 1962 movies11. Busy years for Rock Hudson- 代表省略 与前面题型相同* 代表错题，重点看6. Cast list for CasablancaObtain the cast list for ‘C
2020-11-21 19:35:37
368
2
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人