/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 vote178 views1 answer
Aktor yang pernah terlibat di film bergenre Aksi di sql
SQL
0 vote173 views1 answer
Sql reverse order of results
SQL
0 vote191 views1 answer
Insufficient privileges while creating view in sql oracle
SQL
0 vote160 views1 answer
How to concatenate text from multiple rows into a single text string in SQL Server
SQL
46 votes249 views4 answers
Create column sql
SQL
0 vote169 views1 answer
Datetime postgres typeorm
SQL
0 vote218 views1 answer
Error code 1215 cannot add foreign key constraint
SQL
0 vote166 views1 answer
How to use group_concat in sql server
SQL
0 vote165 views2 answers
How to update date in oracle
SQL
-2 votes172 views1 answer
Use of where in left join in mysql
SQL