帮我写一个sql语句,

问题描述:

帮我写一个sql语句,
Which countries are not too small and not too big?
BETWEEN allows range checking - note that it is inclusive.
e.g:
SELECT name,area FROM bbc
WHERE area BETWEEN 207600 AND 244820
QUESTION:
Show the area in 1000 square km.Show area/1000instead of area
就是此页面的最后一个题,验证了答案再发啊.
1个回答 分类:英语 2014-11-27

问题解答:

我来补答
如果你Area里面存的是平方米,而查询的时候,使用的是平方公里,则使用以下语句:
SELECT name,area,area/1000 AS area_square_km FROM bbc
WHERE area BETWEEN 207600 AND 244820
如果查询的时候,输入的条件也是平方公里,则使用以下语句:
SELECT name,area,area/1000 AS area_square_km FROM bbc
WHERE area/1000 BETWEEN 207600 AND 244820
 
 
展开全文阅读
剩余:2000