/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 vote265 views1 answer
How to drop function in sql
SQL
0 vote264 views2 answers
Android sqlite tutorial for beginners
SQL
3 votes279 views2 answers
Tsql join multiple record in one string
SQL
0 vote288 views3 answers
Join
SQL
0 vote274 views1 answer
Jenkins SQLCMD run
SQL
0 vote294 views1 answer
Postgres multiple left join causing duplicates jsonb_agg
SQL
2 votes327 views1 answer
Create delete procedure mysql
SQL
5 votes310 views1 answer
Mysql where one year ago
SQL
9 votes276 views2 answers
Sql server check table exists
SQL
3 votes264 views2 answers
Oracle apex charging debug
SQL