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 vote364 views1 answer
How to compile a function in oracle
SQL
0 vote345 views1 answer
Get primary key of table
SQL
0 vote329 views1 answer
Add a new column into table
SQL
0 vote304 views1 answer
Google cloud sql postgres url example
SQL
3 votes318 views1 answer
Stpop start psql server
SQL
0 vote360 views2 answers
How to install psql in ubuntu
SQL
0 vote309 views1 answer
Oracle create package specification
SQL
0 vote352 views1 answer
Creating sqeuence in oracle database
SQL
1 vote354 views1 answer
Sql insert for each distinct value
SQL
0 vote341 views1 answer
Sql injection payload list github
SQL