/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 vote138 views1 answer
Postgres type equivalent to timespan c#
SQL
9 votes133 views1 answer
Sql server get utc date
SQL
5 votes134 views2 answers
Postgres update with if condition query
SQL
0 vote174 views1 answer
Reset a table's identity column and remove test records
SQL
1 vote139 views1 answer
Right outer vs left outer join
SQL
0 vote149 views1 answer
Grant privileges mysql to database 1064
SQL
1 vote155 views2 answers
Oracle leftmost characters
SQL
0 vote173 views1 answer
Mysql select random rows large table
SQL
0 vote140 views1 answer
How to to get current date in sql
SQL
0 vote153 views1 answer
To_date sql
SQL