在下面的任务中,我执行了这个查询select max(length(CITY ))from STATION union select min(length(CITY ))from STATION )Group by length(CITY )我收到了,也做了另一个类似的查询
Select max(length(CITY)),CITY from STATION Group by length(CI
第一步:我想返回城市列表,按长度排序的城市长度(城市)要使用ROWNUMBER = 1。要选择名称最短的城市:SELECT DISTINCT city, LENGTH(city) FROM station ORDER BY LENGTH(city) ASC;SELECT DISTINCT city, LENGTH(city) FROM station ORDE