/SQL/Order by number of character in sql

Order by number of character in sql

You can also sort or order by the Number of Characters in each Column you wish 
to sort by. Shown below is a sample which sorts by the first three characters 
of the First Name and by the last two characters in the name of the town.

    SELECT *
    FROM table_name
    ORDER BY LEFT(FirstName, 3) ASC, LEFT(Town, 2);

Similar codes

1 vote182 views1 answer
Oracle aleter trigger ora-01031
SQL
18 votes167 views2 answers
Sql comments
SQL
6 votes197 views2 answers
Mysql 1 day ago
SQL
16 votes182 views2 answers
Oracle ddl
SQL
1 vote167 views1 answer
Column with prefix in sql
SQL
0 vote187 views1 answer
Php get closest location by latitude longitude
SQL
1 vote179 views1 answer
Oracle extract minute from date
SQL
0 vote186 views1 answer
How to change mysql port in xampp
SQL
1 vote176 views1 answer
Find difference in dates sql
SQL
0 vote220 views1 answer
Sqlalchemy _in array sqlite
SQL