/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

2 votes178 views2 answers
Oracle multiple insert
SQL
4 votes206 views4 answers
Mysql get date from datetime
SQL
0 vote195 views1 answer
How to tell if i have lactose intolerance
SQL
2 votes170 views2 answers
How to check database username and password in postgresql
SQL
0 vote181 views1 answer
Sql select all tables from database change url
SQL
0 vote185 views1 answer
Mysql docker image arjun
SQL
3 votes204 views2 answers
Mysql select database
SQL
8 votes177 views3 answers
Oracle auto_increment
SQL
0 vote183 views1 answer
Jdbc sql connection string
SQL
0 vote174 views4 answers
Mysql desactivar trigger
SQL