Get first 3 letters in sql

-- substr(string, start, [, length ])
SELECT substr('Hello World', 1, 3) ;      -- Hel
SELECT substr('Hello World', 4, 5) ;      -- lo Wo
SELECT substr('Hello World', 4);          -- lo World
SELECT substr('Hello World', -3);         -- rld

Get first 3 letters in sql

SELECT FIRST_NAME ,  SUBSTR(FIRST_NAME, 1 , 3 ) , LENGTH(FIRST_NAME)
FROM EMPLOYEES ;

Similar codes

0 vote298 views1 answer
Mysql trigger to delete old data
SQL
1 vote275 views2 answers
Logical operators in sql
SQL
4 votes306 views1 answer
Oracle nls_date_format
SQL
0 vote284 views1 answer
How to make full text search dynamic in mysql
SQL
12 votes299 views2 answers
Insert multiple rows from another table sql
SQL
0 vote273 views1 answer
Components/Fields of Internal Table
SQL
0 vote283 views1 answer
Create table sql generator
SQL
1 vote335 views1 answer
OSError: mysql_config not found
SQL
6 votes293 views2 answers
Non relational database
SQL
5 votes277 views2 answers
Oracle list columns schema
SQL