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 vote294 views1 answer
Postgres call view
SQL
0 vote318 views1 answer
How to find lowest in sql
SQL
0 vote304 views1 answer
Postgresql default value boolean
SQL
0 vote307 views1 answer
Oracle DROP PROGRAM
SQL
0 vote331 views1 answer
Postgres meta command to show all rows in table
SQL
0 vote312 views2 answers
Enter into postgresql database,create user and grant Access
SQL
4 votes303 views1 answer
Is there any command to change postgres password
SQL
1 vote316 views1 answer
Get create table query existing table mysql
SQL
0 vote346 views1 answer
What logs are available on RDS MySQL?
SQL
1 vote305 views1 answer
Oracle sql listagg
SQL