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:

SELECT UPPER(first_name) 
FROM employees;

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.