/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 vote125 views1 answer
Limiting query result using where in sql
SQL
20 votes145 views6 answers
Mysql reset auto increment
SQL
5 votes122 views2 answers
Umgebungsvariable setzen für mysql 8
SQL
0 vote124 views1 answer
Sqldf change user
SQL
3 votes133 views2 answers
Having in mysql
SQL
1 vote130 views1 answer
Hackerrank sql test solutions
SQL
14 votes138 views2 answers
Oracle export trigger ddl
SQL
11 votes146 views5 answers
Sql server reset identity
SQL
5 votes144 views1 answer
Purge undo tablespace oracle 11g
SQL
1 vote139 views1 answer
Mysql add fields
SQL