/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

9 votes334 views3 answers
Where in sql
SQL
1 vote384 views1 answer
Print all records of table in mysql
SQL
-1 vote383 views1 answer
Brisanje dupliranih konatakata
SQL
10 votes379 views2 answers
What is database
SQL
-1 vote375 views4 answers
Postgres between dates
SQL
1 vote361 views1 answer
Date_part mysql
SQL
15 votes627 views2 answers
How to sort names in alphabetical order in sql
SQL
0 vote344 views2 answers
Clear window pl sql
SQL
1 vote350 views1 answer
How to check the mysql version mac
SQL
0 vote399 views1 answer
Mysql where sum > 0
SQL