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.

Sample Solution:

Code:

SELECT  CONCAT(first_name,' ', last_name) "Employee Name" 
FROM employees;

Sample table: employees

Output:

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)

Practice Online

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous: Write a query to calculate the expression 171*214+625.
Next: Write a query to get the first names after removing all the leading and trailing blanks of all the employees from employees table.