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 vote406 views1 answer
ORA-32794: cannot drop a system-generated sequence
SQL
6 votes357 views2 answers
How to get yesterday date in mysql
SQL
0 vote341 views1 answer
Mysql get last 2 month data
SQL
1 vote325 views1 answer
Timestamp in sqlite
SQL
0 vote327 views1 answer
Mysql count with two joins
SQL
3 votes331 views1 answer
Sql server version query
SQL
0 vote320 views1 answer
How to get table current identity value in sql server
SQL
3 votes332 views1 answer
Force using index oracle
SQL
0 vote338 views1 answer
Why we have to set the password for my sql server
SQL
4 votes388 views1 answer
Mysql delete last row
SQL