/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 vote124 views3 answers
How to restart mysql in linux
SQL
1 vote139 views1 answer
Sqlite update from another table
SQL
3 votes151 views3 answers
Order by postgres
SQL
8 votes124 views3 answers
Oracle auto_increment
SQL
0 vote128 views1 answer
Create user faunadb
SQL
2 votes125 views1 answer
How to search table name in stored procedure in sql server
SQL
1 vote136 views1 answer
Sql server today minus n
SQL
1 vote124 views1 answer
Clear screen command in psql
SQL
0 vote137 views1 answer
Select insert new table sql server
SQL
7 votes121 views4 answers
Lowest salary in sql
SQL