/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

3 votes53 views2 answers
Mysql sum with condition
SQL
6 votes87 views1 answer
Oracle rank() over (partition)
SQL
1 vote116 views1 answer
Postgres left join
SQL
0 vote107 views1 answer
UNION ALL LEFT JOIN
SQL
0 vote106 views1 answer
Sql: extract day text from datetime value
SQL
17 votes114 views3 answers
Postgresql list users
SQL
4 votes102 views1 answer
Select first and last row sql
SQL
0 vote59 views1 answer
Print sum of values sql
SQL
0 vote110 views1 answer
Get substract count sql
SQL
0 vote123 views1 answer
Hallo
SQL