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:

-- Concatenating the first name and last name with a space in between to form the full employee name
SELECT CONCAT(first_name, ' ', last_name) AS "Employee Name" 
-- Selecting data from the employees table
FROM employees;

Explanation:

• This SQL code concatenates the first name and last name of employees with a space in between to form the full employee name.
• The CONCAT() function is used to concatenate the first name, a space character, and the last name.
• The result set will contain a single column named "Employee Name" with the concatenated full names of 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.