/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

0 vote248 views5 answers
Select concat alter table mysql
SQL
1 vote220 views1 answer
Oracle compile schema
SQL
5 votes211 views1 answer
Mysql select greater than yesterday
SQL
0 vote194 views1 answer
How to insert multiple values in a single column in sql
SQL
0 vote206 views2 answers
What is the library that should import to use all functional database features in SQLite?
SQL
19 votes237 views5 answers
Display table in sql
SQL
1 vote253 views1 answer
Mysql stop password policy
SQL
4 votes196 views4 answers
Rollback in sql
SQL
1 vote232 views1 answer
Nvl postgres
SQL
0 vote255 views1 answer
Check user sql password from command line
SQL