w3resource

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.

What is the difficulty level of this exercise?



New Content: Composer: Dependency manager for PHP, R Programming