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