/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

6 votes183 views1 answer
Oracle desc table primary key
SQL
0 vote209 views1 answer
Repeatable read trong sql server
SQL
0 vote395 views1 answer
Redirection 301 htaccess nom de domaine
SQL
0 vote174 views1 answer
Sql contains numeric characters
SQL
0 vote186 views1 answer
How to create a table based on another table in mysql
SQL
19 votes212 views6 answers
Create table sqlite
SQL
4 votes195 views1 answer
Id increment ms sql server
SQL
3 votes237 views1 answer
Flutter sqlite auto incrementing id primary key
SQL
8 votes234 views2 answers
Default sql server port
SQL
0 vote225 views1 answer
Alter fedora mysql 8.0 user
SQL