/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 vote73 views1 answer
Postgres create database if not exists
SQL
0 vote95 views1 answer
Mysql cdn link
SQL
13 votes98 views5 answers
Select last row mysql
SQL
1 vote99 views2 answers
Create a unqie constraint mysql
SQL
0 vote100 views1 answer
Insert or update cassandra
SQL
23 votes139 views6 answers
Create table sql
SQL
0 vote88 views1 answer
Load utilities in sql server
SQL
1 vote104 views1 answer
Insert column after column mysql
SQL
0 vote110 views1 answer
MySQL - How to find word with the most similar beginning
SQL
1 vote99 views1 answer
T-sql find object by name
SQL