w3resource

PostgreSQL String() Function: Find the details of employees who contain eight or more characters in their first name


3. Write a query to find the details of those employees who contain eight or more characters in their first name.

Sample Solution:

Code:

SELECT * 
FROM employees  
WHERE LENGTH(first_name) >= 8;

Sample table: employees


Output:

pg_exercises=# SELECT *
pg_exercises-# FROM employees
pg_exercises-# WHERE LENGTH(first_name) >= 8;
 employee_id | first_name  | last_name |     email     |    phone_number    | hire_date  |   job_id   |  salary  | commission_pct | manager_id | department_id
-------------+-------------+-----------+---------------+--------------------+------------+------------+----------+----------------+------------+---------------
         103 | Alexander   | Hunold    | not available | 590.423.4567       | 1987-06-20 | IT_PROG    |  9030.00 |           0.10 |        102 |            60
         115 | Alexander   | Khoo      | not available | 515.127.4562       | 1987-07-02 | PU_CLERK   |  3130.00 |           0.10 |        114 |            30
         176 | Jonathon    | Taylor    | not available | 011.44.1644.429265 | 1987-09-01 | SA_REP     |  8630.00 |           0.10 |        149 |            80
         178 | Kimberely   | Grant     | not available | 011.44.1644.429263 | 1987-09-03 | SA_REP     |  7030.00 |           0.10 |        149 |             0
         153 | Christopher | Olsen     | not available | 011.44.1344.498718 | 1987-08-09 | SA_REP     |  8030.00 |           0.10 |        145 |            80
         189 | Jennifer    | Dilly     | not available | 650.505.2876       | 1987-09-14 | SH_CLERK   |  3630.00 |           0.10 |        122 |            50
         112 | Jose Manuel | Urman     | not available | 515.123.4469       | 1987-06-29 | FI_ACCOUNT |  7830.00 |           0.10 |        108 |           100
         169 | Harrison    | Bloom     | not available | 011.44.1343.829268 | 1987-08-25 | SA_REP     | 10030.00 |           0.10 |        148 |            80
         172 | Elizabeth   | Bates     | not available | 011.44.1343.529268 | 1987-08-28 | SA_REP     |  7330.00 |           0.10 |        148 |            80
         200 | Jennifer    | Whalen    | not available | 515.123.4444       | 19:

Practice Online


Have another way to solve this solution? Contribute your code (and comments) through Disqus.

What is the difficulty level of this exercise?



New Content: Composer: Dependency manager for PHP, R Programming