w3resource

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)

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