帮我写一个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/08 02:34:45
![帮我写一个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](/uploads/image/z/9261225-9-5.jpg?t=%E5%B8%AE%E6%88%91%E5%86%99%E4%B8%80%E4%B8%AAsql%E8%AF%AD%E5%8F%A5%2CWhich+countries+are+not+too+small+and+not+too+big%3FBETWEEN+allows+range+checking+-+note+that+it+is+inclusive.e.g%3ASELECT+name%2Carea+FROM+bbcWHERE+area+BETWEEN+207600+AND+244820QUESTION%3AShow+the+area+in+1000+square+km.Show+area%2F1)
帮我写一个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