/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 vote170 views1 answer
Sql datediff month
SQL
0 vote167 views1 answer
How to update rows from a table when certain conditions are met in mysql
SQL
1 vote167 views1 answer
Base nosql
SQL
0 vote177 views1 answer
Changing name of column and datatype in sql
SQL
2 votes159 views2 answers
Mysql on duplicate key ignore
SQL
1 vote185 views1 answer
Get parameter value in mysql trigger
SQL
0 vote169 views1 answer
Mysql 8 geo to json
SQL
9 votes183 views2 answers
Sql server check table exists
SQL
5 votes170 views1 answer
How to check nls format in oracle
SQL
14 votes181 views1 answer
Oracle alter table add column not null
SQL