/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 vote166 views1 answer
Pentaho + pasar de excel a sql
SQL
8 votes189 views3 answers
Find table for column name in sql
SQL
0 vote146 views1 answer
How to Remove milliseconds from Date time
SQL
9 votes156 views3 answers
Sql delete where in
SQL
0 vote154 views1 answer
Mysql query single row
SQL
1 vote181 views2 answers
Limit sqlserver
SQL
-1 vote155 views3 answers
SQL to LINQ converter
SQL
2 votes153 views1 answer
Sqlite show table indexes
SQL
0 vote151 views1 answer
Sql insert tuple
SQL
0 vote147 views1 answer
How to define a save method in ruby for sql databases
SQL