PostgreSQL Basic SELECT Statement: Get the first three characters of the first name for all employees
12. Write a query to get the first three characters of the first name for all the employees in the employees table.
Sample Solution:
Code:
SELECT SUBSTRING(first_name,1,3)
FROM employees;
Sample table: employees
Output:
pg_exercises=# SELECT SUBSTRING(first_name,1,3) pg_exercises-# FROM employees; substring ----------- Ste Nee Lex Ale Bru Dav Val Dia Nan Dan Joh Ism Jos Lui Den Ale She Sig Guy Kar Mat Ada Pay Sha Kev ... Sus Her She Wil (107 rows)
Practice Online
Have another way to solve this solution? Contribute your code (and comments) through Disqus.
Previous: Write a query to get all the first name from the employees table in upper case.
Next: Write a query to calculate the expression 171*214+625.
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