/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 vote221 views2 answers
Mysql extract number from string
SQL
0 vote214 views2 answers
Plpgsql
SQL
0 vote190 views1 answer
Call function sql oracle
SQL
1 vote238 views1 answer
Drop colum oracle 18c
SQL
0 vote216 views1 answer
How to create notes in mysql
SQL
1 vote189 views1 answer
Psql connections
SQL
0 vote194 views1 answer
Psql datestyle
SQL
0 vote193 views1 answer
Original Query
SQL
2 votes231 views1 answer
Sql string starts with
SQL
1 vote207 views1 answer
Too many connections mysql
SQL