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 vote186 views1 answer
How to set up an anonymous function to variable in swift
SQL
1 vote164 views1 answer
Oracle first row
SQL
0 vote163 views1 answer
Mysql connection with sqlalchecmy
SQL
10 votes192 views4 answers
Inner join in update query mysql
SQL
2 votes167 views1 answer
Mysql clear screen
SQL
0 vote185 views1 answer
Second Step in installing SQL workbench
SQL
6 votes266 views3 answers
Psql show columns of table
SQL
0 vote182 views1 answer
What is top n result in sql
SQL
0 vote173 views1 answer
Create schema sql server
SQL
0 vote173 views1 answer
Selecting duplicates
SQL