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

17 votes151 views6 answers
Change column name in sql
SQL
2 votes157 views1 answer
Sql get the name of user pc
SQL
0 vote170 views1 answer
Cannot insert duplicate key in object 'dbo.Instructor'. The duplicate key value is (2).
SQL
8 votes149 views1 answer
How to check mysql version in xampp
SQL
1 vote140 views1 answer
Neo4j display all nodes and relationships
SQL
1 vote142 views1 answer
Psql connections
SQL
0 vote138 views1 answer
Postgres add prefix to primary key
SQL
0 vote144 views4 answers
Postgresql between month
SQL
25 votes165 views6 answers
How to change column name in mysql
SQL
1 vote156 views1 answer
Sql where max date
SQL