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.
SELECT last_name FROM employees WHERE last_name LIKE '__e%';
Sample table: employees
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)
Have another way to solve this solution? Contribute your code (and comments) through Disqus.
What is the difficulty level of this exercise?