/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 vote171 views1 answer
Output table plsql
SQL
0 vote181 views1 answer
Oracle procedure teamplate
SQL
1 vote177 views1 answer
Mysql copy table1 to table2
SQL
0 vote177 views1 answer
Synapse sql table set pk
SQL
-1 vote183 views3 answers
Compute age mysql
SQL
1 vote189 views1 answer
Check current sequence value postgres
SQL
0 vote177 views1 answer
Execute sql stored procedure in powershell
SQL
1 vote166 views1 answer
Oracle create index if not exists
SQL
0 vote163 views3 answers
Sql parenthetical expression examples
SQL
0 vote166 views1 answer
Top 3 salary in sql
SQL