w3resource

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

Employee Model  Database - w3resource online SQLite practice

Structure of 'hr' database :

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?



Share this Tutorial / Exercise on : Facebook and Twitter