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 vote168 views2 answers
Uninstall postgresql mac
SQL
0 vote163 views1 answer
Function plsql
SQL
1 vote146 views1 answer
Random name function in mysql for nvarchar
SQL
3 votes189 views1 answer
Sql several or
SQL
0 vote149 views1 answer
Createdb with postgresql on ubuntu
SQL
0 vote148 views2 answers
Sql query for getting details by id
SQL
2 votes145 views2 answers
TSQL GET ALL COLUMNS IN TABLE
SQL
0 vote162 views1 answer
Hierarchal database table
SQL
0 vote135 views1 answer
How to print out column name differently in mysql
SQL
0 vote105 views1 answer
Select all domains of database firbird
SQL