/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 vote220 views1 answer
How to import pymysql through jupyter notebook for windows
SQL
0 vote156 views1 answer
Microsoft sql server management studio clear cache
SQL
5 votes161 views1 answer
Copy table from one database to another mysql
SQL
1 vote209 views1 answer
Show table status command in mysql
SQL
0 vote227 views1 answer
Query for backup a database at another location in file system
SQL
0 vote227 views1 answer
How to find lowest in sql
SQL
0 vote183 views1 answer
Get who is hired in month in sql
SQL
0 vote202 views1 answer
Sql select upcoming birthdays
SQL
15 votes224 views6 answers
Laravel db transaction
SQL
10 votes378 views4 answers
Mysql if else
SQL