PostgreSQL Restricting and Sorting Data: Display the last name of employees having 'e' as third character

8. Write a query to display the last name of employees having 'e' as the third character.

Sample Solution:

Code:

SELECT last_name 
FROM employees 
WHERE last_name LIKE '__e%';

Sample table: employees

Output:

pg_exercises=# SELECT last_name
pg_exercises-# FROM employees
pg_exercises-# WHERE last_name LIKE '__e%';

 last_name
-----------
 Greenberg
 Chen
 Gee
 Greene
 Lee
 Ozer
 Abel
 Fleaur
 Everett
 Feeney
 Baer
 Gietz
(12 rows)

Go to:

• PostgreSQL Restricting and Sorting Data Exercises Home. ↩
• PostgreSQL Exercises Home ↩

PREV : Write a query to display the last name of employees whose name contain exactly six characters.
NEXT : Write a query to display the jobs/designations available in the employees table.

Practice Online

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