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)
Sample table: employees
Output:
need an explanation for this answer? contact us directly to get an explanation for this answer