/SQL/Sql finding longest and shortest names in a fleld

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)

Similar codes

0 vote154 views2 answers
Add colum in sql
SQL
0 vote157 views1 answer
Mysql procedure between two tables
SQL
0 vote152 views1 answer
Soql update query
SQL
12 votes136 views5 answers
Sql merge
SQL
0 vote192 views1 answer
SQL-Arten
SQL
4 votes149 views4 answers
What is primary key
SQL
0 vote145 views1 answer
Oracle free up space in tablespace
SQL
8 votes167 views1 answer
Script to add datafile to tablespace
SQL
4 votes149 views2 answers
Tsql utf to local time
SQL
0 vote169 views1 answer
Mysql pv progres
SQL