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

1 vote256 views1 answer
Oracle rolling back transactions
SQL
1 vote270 views1 answer
Incompatible sql_mode=only_full_group_by
SQL
7 votes252 views2 answers
Get database size mysql
SQL
0 vote221 views1 answer
Get last run query sql server
SQL
6 votes270 views2 answers
How to copy data in sql
SQL
0 vote245 views1 answer
What is the essence of SQL?
SQL
4 votes281 views2 answers
Dbms output
SQL
0 vote293 views1 answer
Buscar nombre de columna en todas las tablas sql server
SQL
0 vote256 views1 answer
Uuid sqlalcomany
SQL
0 vote261 views3 answers
Average salary in sql
SQL