/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

3 votes253 views3 answers
How to add month in update sql
SQL
3 votes258 views1 answer
Apex set debug level
SQL
0 vote246 views1 answer
Mql5 list all available symbols
SQL
0 vote260 views1 answer
Zerar auto increment mysql
SQL
1 vote259 views1 answer
Oracle stop
SQL
-1 vote268 views1 answer
Can pandas fetch data from sql
SQL
0 vote263 views1 answer
Setval in postgres
SQL
12 votes262 views1 answer
Script to add new column in table sql
SQL
0 vote252 views1 answer
How to return only the Date from a SQL Server DateTime datatype
SQL
19 votes242 views6 answers
Laravel sql query
SQL