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.
SELECT UPPER(first_name) FROM employees;
Sample table: employees
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)
Have another way to solve this solution? Contribute your code (and comments) through Disqus.
What is the difficulty level of this exercise?