/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 vote114 views1 answer
Sql select data from one database and insert into a different database
SQL
1 vote111 views1 answer
Postgres concat_ws
SQL
4 votes103 views6 answers
Sql select statement
SQL
3 votes101 views3 answers
Print in pl sql
SQL
2 votes111 views1 answer
Sql column values comma separated
SQL
7 votes113 views1 answer
Oracle pagination query offset
SQL
2 votes109 views1 answer
SELECT LOCKED FROM public.databasechangeloglock WHERE ID=1
SQL
0 vote126 views1 answer
How to get parent and child record in single query using sql
SQL
0 vote101 views1 answer
Min mysql
SQL
0 vote105 views1 answer
Postgresql remove new line from string
SQL