/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

10 votes220 views1 answer
All_dependencies
SQL
3 votes240 views1 answer
Postgres count distinct
SQL
-1 vote244 views4 answers
Sql view postgresql
SQL
0 vote250 views1 answer
Hour differeence in mysql
SQL
0 vote227 views1 answer
Storing RGBA in mysql db
SQL
0 vote188 views1 answer
Bigquery information_schema schema all columns
SQL
9 votes256 views3 answers
Date format in sql
SQL
1 vote212 views1 answer
Mysql count words
SQL
2 votes228 views1 answer
Find all triggers in database
SQL
1 vote240 views1 answer
Oracle grant select on schema
SQL