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.

Previous: 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.

What is the difficulty level of this exercise?



Follow us on Facebook and Twitter for latest update.