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 vote231 views1 answer
Initcap in mysql
SQL
1 vote270 views1 answer
Delete mysql ubuntu 20.04
SQL
0 vote226 views1 answer
Oracle shrink table
SQL
0 vote221 views2 answers
Sqlite
SQL
0 vote229 views1 answer
Do you know sql
SQL
0 vote237 views1 answer
Sql date between one week
SQL
0 vote228 views1 answer
Create table in dbms cmds
SQL
0 vote216 views1 answer
Job for mysql.service failed because the control process exited with error code.
SQL
0 vote223 views1 answer
Sql server: how to assign value to table variable returned from function
SQL
0 vote360 views2 answers
Create new table from existing table with data in sql server
SQL