PostgreSQL Basic SELECT Statement: Get the name, including first name and last name of all the employees
14. Write a query to get the name, including first name and last name of all the employees from employees table.
SELECT CONCAT(first_name,' ', last_name) "Employee Name" FROM employees;
Sample table: employees
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)
Have another way to solve this solution? Contribute your code (and comments) through Disqus.
What is the difficulty level of this exercise?