(Contents)(Previous)(Next)

Determining the Number of~Characters

The table 'customer' is sorted according to the lengths of the names. If names have the same length, they are sorted in alphabetically ascending order.

SELECT name, LENGTH(name) length_of_name

FROM customer

ORDER BY length, name


(Contents)(Previous)(Next)