¿Cómo encuentro el nombre de ciudad más corto y más largo en SQL?

How do I find the shortest and longest city name in SQL?

When ordered alphabetically, the CITY names are listed as ABC, DEF, PQRS, and WXY, with the respective lengths 3, 3, 4 and 3. The longest-named city is obviously PQRS, but there are 3 options for shortest-named city; we choose ABC, because it comes first alphabetically.

The shortest firstName : (SELECT min(len()) FROM ) ; Example : SELECT TOP 1 * FROM friends WHERE len(firstName) = (SELECT min(len(firstName)) FROM friends);

SELECT SUBSTRING(Col_Name, 1, 1) AS ExtractString; Parameters used in the SUBSTRING method is as follows: 1. Col_Name: This is required to extract the string.

Select City, length (City) from Station where City in (Select City from Station where length (City) in (Select max (length (City)) from Station)) OR City in (Select min (City) from Station where length (City) in (Select min (length (City)) from Station)) order by City asc; WOW!! Thanks for contributing an answer to Stack Overflow!

Closed 4 years ago. Query: Query the two cities in STATION with the shortest and longest CITY names, as well as their respective lengths (i.e.: number of characters in the name). If there is more than one smallest or largest city, choose the one that comes first when ordered alphabetically.

SELECT CITY, LENGTH (CITY) FROM STATION ORDER BY LENGTH (CITY), CITY ASC LIMIT 1; SELECT CITY, LENGTH (CITY) FROM STATION ORDER BY LENGTH (CITY) DESC LIMIT 1; I think, presentation matters. My solution shows each parts separately in a human readable manner.

Then all you need is an outer query to filter the results to only the shortest (or longest) name: If you want to return all the cities with the shortest (or longest) name then use DENSE_RANK instead of ROW_NUMBER: The 1st query inside returns the city with the minimum length, while the 2nd query returns the city with the maximum length.