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 vote232 views1 answer
Openquery update linked server
SQL
16 votes206 views2 answers
Add column if not exists mysql
SQL
0 vote226 views1 answer
Regex any word except sql
SQL
0 vote204 views1 answer
Jdbc sql connection string
SQL
-1 vote216 views5 answers
Operator in sql
SQL
0 vote221 views1 answer
Str_to_date sql server
SQL
14 votes202 views2 answers
Oracle limit rows
SQL
0 vote194 views1 answer
Ajouter une contrainte de clé étrangère sql
SQL
6 votes207 views2 answers
Stored procedure to delete data from table in mysql
SQL
4 votes212 views3 answers
Is not null sql
SQL