- 1

Query the two Cities In Station With Shortest and Longest City names.

MySQL Query

20th Jan 2022, 6:08 PM
Danish Siddiqui
2 odpowiedzi
0
¿What is the question? If you need help, please show your attempt first.
20th Jan 2022, 6:11 PM
CGM
CGM - avatar
0
Try to use MAX() to get longest name, and MIN() to get shortest name. SELECT MIN(city_name) AS shortest, MAX(city_name) AS longest FROM cities;
20th Jan 2022, 8:29 PM
Ipang