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 vote189 views1 answer
Reona
SQL
0 vote239 views1 answer
Python mysql executemany
SQL
3 votes193 views2 answers
Monthname sql
SQL
36 votes202 views3 answers
Add column in mysq
SQL
0 vote217 views1 answer
Oracle list dblink
SQL
3 votes187 views1 answer
Locate sql server
SQL
0 vote184 views1 answer
Get time component of datetime sql
SQL
0 vote192 views1 answer
Sql select where more than one record exists
SQL
1 vote203 views1 answer
Postgres left join
SQL
0 vote194 views1 answer
Load SQLite in Jupyter Notebook together with the access to the file
SQL