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

23 votes393 views6 answers
Create table sql server
SQL
0 vote427 views1 answer
Add two days to current date in sql when creating tables
SQL
0 vote372 views1 answer
Sql query contains multiple ids
SQL
0 vote366 views1 answer
Mysql exception output
SQL
2 votes339 views1 answer
Mysql time ago difference
SQL
0 vote366 views1 answer
Check if a column is a primary key in sql server
SQL
0 vote327 views1 answer
How many columns can be used for creating index?
SQL
0 vote359 views1 answer
Sql query to find duplicate email address
SQL
0 vote380 views1 answer
Postgresql inheritance
SQL
1 vote332 views1 answer
Mysql show current queries
SQL