/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 vote121 views1 answer
Create function in microsoft sql server
SQL
17 votes74 views6 answers
What is cursor in sql server with example
SQL
12 votes119 views6 answers
Between in sql
SQL
5 votes136 views1 answer
Oracle get ddl
SQL
2 votes122 views1 answer
Guid to string sql
SQL
4 votes135 views2 answers
Float postgres
SQL
11 votes120 views4 answers
Update row in mysql
SQL
-1 vote118 views1 answer
Count occurrences sql
SQL
0 vote116 views1 answer
How to open mysql in docker
SQL
0 vote121 views1 answer
For row in sql database python loop
SQL