/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

4 votes376 views2 answers
Could not find driver (SQL: SHOW FULL TABLES WHERE table_type = 'BASE TABLE')
SQL
3 votes328 views3 answers
Your password does not satisfy the current policy requirements
SQL
1 vote326 views1 answer
Mysql change root mysql_native_password
SQL
1 vote317 views1 answer
Sql select where id not exists in another table
SQL
0 vote364 views1 answer
Pl/pgsql declare variable
SQL
1 vote333 views1 answer
Mysql tables max count
SQL
6 votes370 views2 answers
Foreign key sqlite3 python
SQL
9 votes352 views3 answers
Date format in sql
SQL
0 vote340 views1 answer
Mariadb alter table add column if not exists example
SQL
1 vote358 views3 answers
Alter schema sql server
SQL