mysql----Nested SELECT Quiz
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了mysql----Nested SELECT Quiz,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含4579字,纯文字阅读大概需要7分钟。
内容图文
SELECT region, name, population FROM bbc WHERE population <= ALL (SELECT population FROM bbc WHERE population>0)
SELECT region, name, population FROM bbc x WHERE population <= ALL (SELECT population FROM bbc y WHERE y.region=x.region AND population>0)
SELECT region, name, population FROM bbc x WHERE population = ALL (SELECT population FROM bbc y WHERE y.region=x.region AND population>0)
SELECT region, name, population FROM bbc x WHERE population <= ALL (SELECT population FROM bbc y WHERE y.region=x.region AND population<0)
2. Select the code that shows the countries belonging to regions with all populations over 50000
SELECT name,region,population FROM bbc x WHERE 50000 < ALL (SELECT population FROM bbc y WHERE population>0)
SELECT name,region,population FROM bbc x WHERE 50000 < ALL (SELECT population FROM bbc y WHERE x.region=y.region AND y.population>0)
SELECT name,region,population FROM bbc x WHERE 50000 = ALL (SELECT population FROM bbc y WHERE x.region=y.region AND y.population>0)
SELECT name,region,population FROM bbc x WHERE 50000 > ALL (SELECT population FROM bbc y WHERE x.region=y.region AND y.population>0)
SELECT name,region,population FROM bbc x WHERE 500000 < ALL (SELECT population FROM bbc y WHERE x.region=y.region AND y.population>0)
3. Select the code that shows the countries with a less than a third of the population of the countries around it
SELECT name, region FROM bbc x
WHERE population < ALL (SELECT population/3 FROM bbc y WHERE y.region = x.region AND y.name != x.name)
SELECT name, region FROM bbc x
WHERE population = ALL (SELECT population/3 FROM bbc y WHERE y.region = x.region AND y.name != x.name)
SELECT name, region FROM bbc x
WHERE population > ALL (SELECT population/3 FROM bbc y WHERE y.region = x.region AND y.name != x.name)
SELECT name, region FROM bbc x WHERE population < ALL (SELECT population*3 FROM bbc y WHERE y.region = x.region AND y.name != x.name)
SELECT name, region FROM bbc x WHERE population < ALL (SELECT population/3 FROM bbc y WHERE y.name != x.name)
4. Select the result that would be obtained from the following code:
SELECT name FROM bbc
WHERE population >
(SELECT population
FROM bbc
WHERE name=‘United Kingdom‘)
AND region IN
(SELECT region
FROM bbc
WHERE name = ‘United Kingdom‘)
Table-A
Andorra |
Albania |
Austria |
Bulgaria |
Table-B
France |
Europe |
Germany |
Europe |
Russia |
Europe |
Turkey |
Europe |
Table-C
France |
Germany |
Andorra |
Albania |
Table-D
France |
Germany |
Russia |
Turkey |
Table-E
France |
Germany |
Russia |
Turkey |
Brazil |
United States of USA |
Canada |
5. Select the code that would show the countries with a greater GDP than any country in Africa (some countries may have NULL gdp values).
SELECT name FROM bbc
WHERE gdp > ALL (SELECT MAX(gdp) FROM bbc WHERE region = ‘Africa‘ AND gdp=0)
SELECT name FROM bbc
WHERE gdp > (SELECT MAX(gdp) FROM bbc WHERE region = ‘Africa‘)
SELECT name FROM bbc
WHERE gdp > ALL (SELECT MIN(gdp) FROM bbc WHERE region = ‘Africa‘)
SELECT name FROM bbc
WHERE gdp > ALL (SELECT gdp FROM bbc WHERE region = ‘Africa‘)
SELECT name FROM bbc
WHERE gdp > ALL (SELECT gdp FROM bbc WHERE region = ‘Africa‘ AND gdp<>NULL)
6. Select the code that shows the countries with population smaller than Russia but bigger than Denmark
SELECT name FROM bbc
WHERE population < (SELECT population FROM bbc WHERE name=‘Denmark‘)
AND population > (SELECT population FROM bbc WHERE name=‘Russia‘)
SELECT name FROM bbc
WHERE population < (SELECT population FROM bbc WHERE name=‘Russia‘)
AND population > (SELECT population FROM bbc WHERE name=‘Denmark‘)
SELECT name FROM bbc
WHERE population = (SELECT population FROM bbc WHERE name=‘Russia‘)
AND population > (SELECT population FROM bbc WHERE name=‘Denmark‘)
SELECT name FROM bbc
WHERE population > (SELECT population FROM bbc WHERE name=‘Russia‘)
AND population > (SELECT population FROM bbc WHERE name=‘Denmark‘)
SELECT name FROM bbc
WHERE population < (SELECT population FROM bbc WHERE name=‘Russia‘
AND population > (SELECT population FROM bbc WHERE name=‘Denmark‘)
7. >Select the result that would be obtained from the following code:
SELECT name FROM bbc
WHERE population > ALL
(SELECT MAX(population)
FROM bbc
WHERE region = ‘Europe‘)
AND region = ‘South Asia‘
Table-A
Afghanistan |
Bhutan |
Nepal |
Sri Lanka |
The Maldives |
Table-B
Bangladesh |
India |
Pakistan |
Table-D
Brazil |
Bangladesh |
China |
India |
Table-E
France |
Germany |
Russia |
Trukey |
mysql----Nested SELECT Quiz
标签:str follow color select null lsp middle long name
本文系统来源:http://www.cnblogs.com/tk55/p/6755229.html
内容总结
以上是互联网集市为您收集整理的mysql----Nested SELECT Quiz全部内容,希望文章能够帮你解决mysql----Nested SELECT Quiz所遇到的程序开发问题。
如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
来源:【匿名】