/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 vote268 views1 answer
Describe table in sql
SQL
0 vote282 views3 answers
How to run sql query
SQL
1 vote307 views1 answer
Delete mysql ubuntu 20.04
SQL
0 vote279 views1 answer
Store case result sql
SQL
1 vote262 views1 answer
How do you use sql in you company
SQL
1 vote257 views1 answer
Sql to mongodb query converter
SQL
1 vote272 views1 answer
Postgres check blocking
SQL
-1 vote261 views1 answer
Adding a new table psql
SQL
0 vote329 views1 answer
Drop table BigQuery table columns
SQL
2 votes287 views1 answer
Oracle insert or update
SQL