PostgreSQL Basic SELECT Statement: Get all the first name in uppercase

11. Write a query to get all the first name from the employees table in upper case.

Sample Solution:

Code:

-- Converting the first name to uppercase for all records in the employees table
SELECT UPPER(first_name) 
-- Selecting data from the employees table
FROM employees;

Explanation:

• This SQL code converts the first name to uppercase for all records in the "employees" table.
• The UPPER() function is used to convert the first name to uppercase.
• The result set will contain a single column with the first names converted to uppercase.

Sample table: employees

Output:

pg_exercises=# SELECT UPPER(first_name)
pg_exercises-# FROM employees;
    upper
-------------
 STEVEN
 NEENA
 LEX
 ALEXANDER
 BRUCE
 DAVID
 VALLI
 DIANA
 NANCY
 DANIEL
 JOHN
 ISMAEL
 JOSE MANUEL
 LUIS
 DEN
 ALEXANDER
 SHELLI
 SIGAL
 GUY
 KAREN
 MATTHEW
 ADAM
 PAYAM
 ...
 HERMANN
 SHELLEY
 WILLIAM
(107 rows)

Practice Online

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

Previous: Write a query to get the unique number of designations available in the employees table.
Next: Write a query to get the first three characters of the first name for all the employees in the employees table.