/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 vote193 views1 answer
Oracle current sequence value
SQL
7 votes127 views1 answer
Oracle reset sequence
SQL
1 vote125 views1 answer
Print year of a date sql
SQL
0 vote72 views1 answer
Resolved [java.sql.SQLException: ORA-29977: Unsupported column type for query registration in guaranteed mode ]
SQL
0 vote120 views1 answer
Change filed order in mysql
SQL
-1 vote130 views3 answers
PS5
SQL
0 vote153 views1 answer
Drop domain postgresql
SQL
-1 vote154 views1 answer
Brisanje dupliranih konatakata
SQL
2 votes115 views1 answer
Alter table add multiple columns postgresql
SQL
0 vote106 views1 answer
In mysql workbench contnent not feching
SQL