Answers for "how to find shortest and longest name in sql using join"

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)

Posted by: Guest on July-06-2020

Code answers related to "how to find shortest and longest name in sql using join"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "how to find shortest and longest name in sql using join"

Code answers related to "how to find shortest and longest name in sql using join"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "how to find shortest and longest name in sql using join"

Code answers related to "how to find shortest and longest name in sql using join"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us