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 vote104 views1 answer
Low level operator in dbms
SQL
1 vote93 views1 answer
Join first name and last name sql
SQL
0 vote106 views1 answer
Postgres drop type
SQL
0 vote109 views1 answer
Sqlite commands
SQL
0 vote109 views1 answer
Mysql 8 geo to json
SQL
0 vote104 views1 answer
Hibernate show sql xml property
SQL
0 vote114 views1 answer
Testing sql queries
SQL
0 vote118 views1 answer
Make parameters nullable in sql server
SQL
0 vote107 views1 answer
How to use sqlcommand
SQL
6 votes109 views2 answers
Foreign key sqlite3 python
SQL