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:
SELECT TRIM(first_name)
FROM employees;
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.
What is the difficulty level of this exercise?
- New Content published on w3resource:
- HTML-CSS Practical: Exercises, Practice, Solution
- Java Regular Expression: Exercises, Practice, Solution
- Scala Programming Exercises, Practice, Solution
- Python Itertools exercises
- Python Numpy exercises
- Python GeoPy Package exercises
- Python Pandas exercises
- Python nltk exercises
- Python BeautifulSoup exercises
- Form Template
- Composer - PHP Package Manager
- PHPUnit - PHP Testing
- Laravel - PHP Framework
- Angular - JavaScript Framework
- Vue - JavaScript Framework
- Jest - JavaScript Testing Framework