/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

6 votes291 views1 answer
Check Table Exists
SQL
0 vote264 views1 answer
Sqlite3 now
SQL
0 vote285 views1 answer
Mysql remove tabs from string
SQL
12 votes298 views4 answers
Mysql ifnull
SQL
4 votes309 views1 answer
Alter session set nls_date_format
SQL
0 vote310 views1 answer
How to print some string in mysql
SQL
0 vote293 views1 answer
Simple plsql program run in oracle sql developer but got the error
SQL
8 votes302 views4 answers
How to calculate the age from date of birth in python
SQL
4 votes296 views1 answer
Refresh postgres config
SQL
0 vote296 views1 answer
Mysql query to add hours to column in table
SQL