w3resource

PostgreSQL Basic SELECT Statement: Get the first three characters of the first name for all employees


12. Write a query to get the first three characters of the first name for all the employees in the employees table.

Sample Solution:

Code:

-- Extracting the first three characters of the first name for all records in the employees table
SELECT SUBSTRING(first_name, 1, 3) 
-- Selecting data from the employees table
FROM employees;

Explanation:

  • This SQL code extracts the first three characters of the first name for all records in the "employees" table.
  • The SUBSTRING() function is used to extract a substring from the first name, starting at the first character (position 1) and taking three characters.
  • The result set will contain a single column with the first three characters of the first name for each employee.

Sample table: employees


Output:

pg_exercises=# SELECT SUBSTRING(first_name,1,3)
pg_exercises-# FROM employees;
 substring
-----------
 Ste
 Nee
 Lex
 Ale
 Bru
 Dav
 Val
 Dia
 Nan
 Dan
 Joh
 Ism
 Jos
 Lui
 Den
 Ale
 She
 Sig
 Guy
 Kar
 Mat
 Ada
 Pay
 Sha
 Kev
 ...
 Sus
 Her
 She
 Wil
(107 rows)

Practice Online



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

Previous: Write a query to get all the first name from the employees table in upper case.
Next: Write a query to calculate the expression 171*214+625.

What is the difficulty level of this exercise?



Follow us on Facebook and Twitter for latest update.