This article is tagged with:
Sql finding longest and shortest names in a fleld
and mysql
sql finding longest and shortest names in a fleld
# IN the example below, "CITY" is the filed, "STATION" is the Table
(SELECT CITY, LENGTH(CITY)
FROM STATION
ORDER BY LENGTH(CITY) ASC, CITY ASC LIMIT 1)
UNION
(SELECT CITY, LENGTH(CITY)
FROM STATION
ORDER BY
LENGTH(CITY) DESC, CITY DESC LIMIT 1)