/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 vote225 views1 answer
SQL Server Splitting a string column into multiple rows, while repeating ID column
SQL
0 vote205 views1 answer
How to reset the database value in SQL server
SQL
0 vote207 views2 answers
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created at' in 'field list' (SQL: insert into `categories` (`category_name`, `user_id`, `created at`) values (sea fish, 1, 2021-09-24 04:17:31))
SQL
1 vote212 views1 answer
Copy postgres table from one schema into another
SQL
0 vote252 views1 answer
Copy from one table to another postgres using matching column
SQL
0 vote213 views2 answers
Search stored procedures by name
SQL
11 votes195 views1 answer
How to get ddl for materialized view
SQL
1 vote203 views1 answer
Create sqlite database in laravel
SQL
0 vote217 views1 answer
Soql queries for not contact related account records in salesforce
SQL
0 vote225 views1 answer
Drop view in mysql
SQL