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)

Relational Algebra Expression:

Relational Algebra Expression: Get the first name of the employee who holds the letter 'c' and 'e' in the first name.

Relational Algebra Tree:

Relational Algebra Tree: Get the first name of the employee who holds the letter 'c' and 'e' in the first name.

Practice Online


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

Previous: Write a query to display the name, including first_name and last_name and hire date for all employees who were hired in 1987.
Next: Write a query to display the last name, job, and salary for all those employees who hasn't worked as a Programmer or a Shipping Clerk, and not drawing the salary $4,500, $10,000, or $15,000.

What is the difficulty level of this exercise?



Follow us on Facebook and Twitter for latest update.