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.
What is the difficulty level of this exercise?
- New Content published on w3resource:
- HTML-CSS Practical: Exercises, Practice, Solution
- Java Regular Expression: Exercises, Practice, Solution
- Scala Programming Exercises, Practice, Solution
- Python Itertools exercises
- Python Numpy exercises
- Python GeoPy Package exercises
- Python Pandas exercises
- Python nltk exercises
- Python BeautifulSoup exercises
- Form Template
- Composer - PHP Package Manager
- PHPUnit - PHP Testing
- Laravel - PHP Framework
- Angular - JavaScript Framework
- Vue - JavaScript Framework
- Jest - JavaScript Testing Framework