w3resource

SQLite Exercise: Get the first 3 characters of first name from employees table

Write a query to get the first 3 characters of first name from employees table.

Sample table : employees


SQLite Code :

SELECT SUBSTRING(first_name,1,3) 
FROM employees;

Structure of 'hr' database :

hr database

Improve this sample solution and post your code through Disqus.

Previous: Write a query get all first name from employees table in upper case.
Next: Write a query to calculate 171*214+625.

What is the difficulty level of this exercise?



Share this Tutorial / Exercise on : Facebook and Twitter