pg_exercises=# SELECT CONCAT(first_name,' ', last_name) "Employee Name"
pg_exercises-# FROM employees;
Employee Name
-------------------
Steven King
Neena Kochhar
Lex De Haan
Alexander Hunold
Bruce Ernst
David Austin
Valli Pataballa
Diana Lorentz
Nancy Greenberg
Daniel Faviet
John Chen
Ismael Sciarra
Jose Manuel Urman
...
Julia Nayer
Irene Mikkilineni
James Landry
Steven Markle
Laura Bissot
Mozhe Atkinson
...
Renske Ladwig
Stephen Stiles
John Seo
Joshua Patel
Trenna Rajs
Curtis Davies
...
Hermann Baer
Shelley Higgins
William Gietz
(107 rows)
Sample table: employees
Output:
need an explanation for this answer? contact us directly to get an explanation for this answer