Lists names from the names table with the longest names first : LENGTH « String « SQL / MySQL

1. SQL / MySQL
2. String
3. LENGTH

Lists names from the names table with the longest names first

        
mysql>
mysql>
mysql> CREATE TABLE name
    -> (
    ->  last_name       CHAR(20),
    ->  first_name      CHAR(20)
    -> );
Query OK, 0 rows affected (0.01 sec)

mysql>
mysql> INSERT INTO name (first_name,last_name) VALUES('Kevin','Brown');
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO name (first_name,last_name) VALUES('Vida','Blue');
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO name (first_name,last_name) VALUES('Pete','Gray');
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO name (first_name,last_name) VALUES('Devon','White');
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO name (first_name,last_name) VALUES('Rondell','White');
Query OK, 1 row affected (0.00 sec)

mysql>
mysql> SELECT * FROM name;
+-----------+------------+
| last_name | first_name |
+-----------+------------+
| Brown     | Kevin      |
| Blue      | Vida       |
| Gray      | Pete       |
| White     | Devon      |
| White     | Rondell    |
+-----------+------------+
5 rows in set (0.00 sec)

mysql>
mysql>
mysql> SELECT CONCAT(first_name,' ',last_name) AS name
    -> FROM name
    -> ORDER BY LENGTH(CONCAT(first_name,' ',last_name)) DESC;
mysql>
mysql>
mysql> drop table name;
Query OK, 0 rows affected (0.00 sec)

   
    
    
    
    
    
    
    
  

Related examples in the same category