﻿ PostgreSQL Basic SELECT Statement: Get the length of the name, including first_name and last_name of all the employees - w3resource

# PostgreSQL Basic SELECT Statement: Get the length of the name, including first_name and last_name of all the employees

16. Write a query to get the first name, last name and the length of the name, including first_name and last_name of all the employees from employees table.

Sample Solution:

Code:

-- Selecting the first name, last name, and the sum of the lengths of the first name and last name for all records in the employees table
SELECT first_name, last_name,
-- Calculating the sum of the lengths of the first name and last name and labeling it as "Length of Names"
LENGTH(first_name) + LENGTH(last_name) AS "Length of Names"
-- Selecting data from the employees table
FROM employees;

Explanation:

• This SQL code selects the first name, last name, and calculates the sum of the lengths of the first name and last name for all records in the "employees" table.
• The LENGTH() function is used to determine the length of each name component.
• The sum of the lengths of the first name and last name is labeled as "Length of Names" using the AS keyword in the SELECT statement.
• The result set will contain three columns: first name, last name, and the calculated length of names.

Sample table: employees

Output:

pg_exercises=# SELECT first_name,last_name,
pg_exercises-# LENGTH(first_name)+LENGTH(last_name)  "Length of  Names"
pg_exercises-# FROM employees;
first_name  |  last_name  | Length of  Names
-------------+-------------+------------------
Steven      | King        |               10
Neena       | Kochhar     |               12
Lex         | De Haan     |               10
Alexander   | Hunold      |               15
Bruce       | Ernst       |               10
David       | Austin      |               11
Valli       | Pataballa   |               14
....
Alexander   | Khoo        |               13
Shelli      | Baida       |               11
Sigal       | Tobias      |               11
Guy         | Himuro      |                9
Karen       | Colmenares  |               15
Matthew     | Weiss       |               12
....
Steven      | Markle      |               12
Laura       | Bissot      |               11
Mozhe       | Atkinson    |               13
James       | Marlow      |               11
TJ          | Olson       |                7
....
Renske      | Ladwig      |               12
Stephen     | Stiles      |               13
John        | Seo         |                7
Joshua      | Patel       |               11
Trenna      | Rajs        |               10
...
Hermann     | Baer        |               11
Shelley     | Higgins     |               14
William     | Gietz       |               12
(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?

﻿

Follow us on Facebook and Twitter for latest update.