/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

11 votes385 views1 answer
Oracle view source
SQL
0 vote361 views1 answer
Print intervals of 15 minutes in sql query
SQL
0 vote343 views1 answer
Wordpress sql change site url
SQL
22 votes392 views3 answers
Year format in date mysql
SQL
0 vote378 views1 answer
Pgsql is not permitted to log in
SQL
0 vote396 views1 answer
How to enable mysql 5.7 root user password on linux
SQL
0 vote427 views1 answer
Generate a random otp in sql server
SQL
0 vote345 views1 answer
Sql create table with references not primary key
SQL
0 vote334 views1 answer
Hallo
SQL
1 vote357 views1 answer
Mysql select if empty result
SQL