w3resource

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.

What is the difficulty level of this exercise?



New Content: Composer: Dependency manager for PHP, R Programming