/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 vote367 views1 answer
Update and keep original value sql
SQL
3 votes356 views1 answer
Mysql load sql from file
SQL
0 vote359 views1 answer
Check sql database table lock
SQL
1 vote314 views1 answer
Mysql see column types
SQL
3 votes370 views3 answers
Docker create postgresql database
SQL
0 vote344 views1 answer
IS THEre any difference between using default and := in plsql
SQL
3 votes394 views2 answers
Check data in table mysql
SQL
0 vote426 views1 answer
Com.mysql.cj.exceptions.InvalidConnectionAttributeException more than one time zone. You must configure either the server or JD value if you want to utilize time zone support.
SQL
14 votes440 views1 answer
How to export db from mysql
SQL
15 votes339 views2 answers
How to know the username of postgresql
SQL