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 :

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.