帮我写一个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 bbcWHERE area BETWEEN 207600 AND 244820QUESTION:Show the area in 1000 square km.Show area/1
来源:学生作业帮助网 编辑:作业帮 时间:2024/08/29 04:34:12
帮我写一个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 bbcWHERE area BETWEEN 207600 AND 244820QUESTION:Show the area in 1000 square km.Show area/1
帮我写一个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
就是此页面的最后一个题,验证了答案再发啊.
帮我写一个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 bbcWHERE area BETWEEN 207600 AND 244820QUESTION:Show the area in 1000 square km.Show area/1
如果你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