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 vote160 views1 answer
Drush SQLSTATE[HY000] [2002] No such file or directory
SQL
25 votes187 views6 answers
Import database mysql command line
SQL
0 vote185 views1 answer
SQL column name Oracle
SQL
34 votes170 views6 answers
Sql change data type
SQL
0 vote177 views1 answer
Mysql add to number
SQL
1 vote164 views2 answers
Postgres copy table from one schema to another
SQL
8 votes163 views1 answer
Alter tablespace add datafile
SQL
1 vote161 views1 answer
Postgres check blocking
SQL
5 votes157 views1 answer
Oracle get nls settings
SQL
7 votes169 views2 answers
Sql server drop temp table if exists
SQL