- 博客(2)
- 资源 (1)
- 收藏
- 关注
原创 Nobel Prizes: Aggregate functions
<br />Using SUM, COUNT, MAX, AVG, DISTINCT and ORDER BY.<br />表如下:<br />SELECT * FROM nobel;<br /><br /> <br /> <br />1,Show the total number of prizes awarded.统计有多少个获奖者<br />SELECT COUNT(subject) FROM nobel<br />1b. List each subject - just once 列出每个奖项-只显
2011-02-21 00:00:00 738
原创 SQLZOO.NET
http://sqlzoo.net/2.htm1a,Show the total population of the world.显示世界人口总和SELECT SUM(population) FROM bbc1b. List all the regions - just once each.列出所有的地区,但每个地区只能显示一次SELECT DISTINCT(region) FROM bbc1c.显示GDP超过所有Africa(非洲)国家总和的国家SELECT name FROM bbc WHERE g
2011-02-19 11:35:00 928
Advanced EFS Data Recovery
2012-01-12
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人