how to print the length min length of city in sql query code example
Example: 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)