Ejemplo: sql encontrando los nombres más largos y más cortos en un campo
# 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)
¡Haz clic para puntuar esta entrada!
(Votos: 0 Promedio: 0)