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 vote158 views1 answer
Sql express database size limit
SQL
0 vote153 views2 answers
Many to many flask-sqlalchemy
SQL
1 vote143 views2 answers
Sql server backup table
SQL
3 votes183 views1 answer
Mysql cli connect with password
SQL
8 votes151 views6 answers
Sql insert
SQL
0 vote149 views1 answer
Pl sql disable trigger
SQL
0 vote140 views1 answer
Remove from table where
SQL
3 votes148 views3 answers
Mysql select table names
SQL
11 votes141 views1 answer
Oracle view ddl
SQL
0 vote155 views4 answers
Sql rownum
SQL