/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

1 vote246 views1 answer
Sometimes i cant edit sql developer
SQL
0 vote248 views1 answer
Oracle for loop on list
SQL
3 votes300 views1 answer
Sql select second max
SQL
0 vote239 views1 answer
Count number of entires by months sql
SQL
0 vote383 views1 answer
The differnece between to values in sql
SQL
0 vote238 views1 answer
Mysql readable output
SQL
0 vote236 views1 answer
Modificar tipo de dato sql server
SQL
0 vote263 views3 answers
Call to undefined function mysql_connect()
SQL
0 vote249 views1 answer
Postgresql combine values in one field
SQL
0 vote247 views1 answer
Select sql in descending order
SQL