mysql列查询_mysql – SQL中的列查询

名称最短的城市：

SELECT City, CHAR_LENGTH(City) AS len

FROM STATION

ORDER BY CHAR_LENGTH(City) ASC, City

LIMIT 1

名字最长的城市：

SELECT City, CHAR_LENGTH(City) AS len

FROM STATION

ORDER BY CHAR_LENGTH(City) DESC, City

LIMIT 1

您可以使用UNION ALL将它们组合成一个语句：

SELECT *

FROM (

SELECT City, CHAR_LENGTH(City) AS len

FROM STATION

ORDER BY CHAR_LENGTH(City) ASC, City

LIMIT 1

) shortest

UNION ALL (

SELECT City, CHAR_LENGTH(City) AS len

FROM STATION

ORDER BY CHAR_LENGTH(City) DESC, City

LIMIT 1

) longest