PostgreSQL Basic SELECT Statement: Get the first name of all the employees after removing leading and trailing blanks

15. Write a query to get the first names after removing all the leading and trailing blanks of all the employees from employees table.

Sample Solution:

Code:

-- Removing leading and trailing whitespace characters from the first name for all records in the employees table
SELECT TRIM(first_name) 
-- Selecting data from the employees table
FROM employees;

Explanation:

• This SQL code removes leading and trailing whitespace characters from the first name for all records in the "employees" table.
• The TRIM() function is used to perform the removal of leading and trailing whitespace characters.
• The result set will contain a single column with the first names after removing any leading and trailing whitespace characters.

Sample table: employees

Output:

pg_exercises=# SELECT TRIM(first_name)
pg_exercises-# FROM employees;
    btrim
-------------
 Steven
 Neena
 Lex
 Alexander
 Bruce
 David
 Valli
 Diana
 ....
 Shelli
 Sigal
 Guy
 Karen
 Matthew
 Adam
 Payam
 Shanta
 Kevin
 ....
 Jason
 Michael
 Ki
 Hazel
 Renske
 Stephen
 John
 Joshua
 Trenna
...
 Hermann
 Shelley
 William
(107 rows)

Practice Online

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

Previous: Write a query to get the name, including first name and last name of all the employees from employees table.
Next: Write a query to get the first name, last name and the length of the name, including first_name and last_name of all the employees from employees table.