- 博客(6)
- 收藏
- 关注
原创 sqlzoo习题答案--Self join
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
2018-06-28 10:01:00 1001
原创 sqlzoo习题答案--More JOIN operations
This tutorial introduces the notion of a join. The databaseconsists of three tables movie , actor and casting .movieidtitleyrdirectorbudgetgrossactoridnamecastingmovieidactoridord<
2018-06-24 17:12:04 545
原创 mysql学习网站链接
1.W3School: http://www.w3school.com.cn/sql/index.asp2.sql练习:http://sqlzoo.net
2018-06-24 10:38:00 653
原创 sqlzoo习题答案--Using Null
5.Use 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 '07986 444 2266'select name,coalesce(mobile,'07986 444 226...
2018-06-22 10:48:51 480
原创 sqlzoo习题答案-Select within Select Tutorial
8.List each continent and the name of the country that comes first alphabetically.select continent,min(name)from worldgroup by continentorder by continent*******方法二*******
2018-06-22 10:30:50 683
原创 sqlzoo习题答案--The join operation
sqlzoo地址:http://sqlzoo.net/wiki1.The join operation(8).show the name of all players who scored a goal against Germany.HINTSelect goals scored only by non-German players in matches where GER was the id...
2018-06-16 19:51:06 1108
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人