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?
- Weekly Trends
- Python Interview Questions and Answers: Comprehensive Guide
- Scala Exercises, Practice, Solution
- Kotlin Exercises practice with solution
- MongoDB Exercises, Practice, Solution
- SQL Exercises, Practice, Solution - JOINS
- Java Basic Programming Exercises
- SQL Subqueries
- Adventureworks Database Exercises
- C# Sharp Basic Exercises
- SQL COUNT() with distinct
- JavaScript String Exercises
- JavaScript HTML Form Validation
- Java Collection Exercises
- SQL COUNT() function
- SQL Inner Join