w3resource

PostgreSQL Restricting and Sorting Data: Get the first name of the employee who holds the letter 'c' and 'e' in the first name


5. Write a query to get the first name of the employee who holds the letter 'c' and 'e' in the first name.

Sample Solution:

Code:

SELECT first_name 
FROM employees 
WHERE first_name LIKE '%c%' 
AND first_name LIKE '%e%';

Sample table: employees


Output:

pg_exercises=# SELECT first_name
pg_exercises-# FROM employees
pg_exercises-# WHERE first_name LIKE '%c%'
pg_exercises-# AND first_name LIKE '%e%';
 first_name
------------
 Bruce
 Michael
 Vance
 Michael
(4 rows)

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