SQLite Exercise: Get all first name from employees table in upper case
Write a query get all first name from employees table in upper case.
Sample table : employees
SQLite Code :
SELECT UPPER(first_name)
FROM employees;
Output:
UPPER(first_name) ----------------- STEVEN NEENA LEX ALEXANDER BRUCE DAVID VALLI DIANA NANCY DANIEL JOHN ISMAEL JOSE MANUEL LUIS DEN ALEXANDER SHELLI SIGAL GUY KAREN MATTHEW ADAM PAYAM SHANTA KEVIN JULIA IRENE JAMES STEVEN LAURA MOZHE JAMES TJ JASON MICHAEL KI HAZEL RENSKE STEPHEN JOHN JOSHUA TRENNA CURTIS RANDALL PETER JOHN KAREN ALBERTO GERALD ELENI PETER DAVID PETER CHRISTOPHER NANETTE OLIVER JANETTE PATRICK ALLAN LINDSEY LOUISE SARATH CLARA DANIELLE MATTEA DAVID SUNDAR AMIT LISA HARRISON TAYLER WILLIAM ELIZABETH SUNDITA ELLEN ALYSSA JONATHON JACK KIMBERELY CHARLES WINSTON JEAN MARTHA GIRARD NANDITA ALEXIS JULIA ANTHONY KELLY JENNIFER TIMOTHY RANDALL SARAH BRITNEY SAMUEL VANCE ALANA KEVIN DONALD DOUGLAS JENNIFER MICHAEL PAT SUSAN HERMANN SHELLEY WILLIAM
Practice SQLite Online
Model Database
Structure of 'hr' database :
Improve this sample solution and post your code through Disqus.
Previous: Write a query to get the number of jobs available in the employees table.
Next: Write a query to get the first 3 characters of first name from employees table.
What is the difficulty level of this exercise?
- New Content published on w3resource:
- HTML-CSS Practical: Exercises, Practice, Solution
- Java Regular Expression: Exercises, Practice, Solution
- Scala Programming Exercises, Practice, Solution
- Python Itertools exercises
- Python Numpy exercises
- Python GeoPy Package exercises
- Python Pandas exercises
- Python nltk exercises
- Python BeautifulSoup exercises
- Form Template
- Composer - PHP Package Manager
- PHPUnit - PHP Testing
- Laravel - PHP Framework
- Angular - JavaScript Framework
- Vue - JavaScript Framework
- Jest - JavaScript Testing Framework