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 vote237 views1 answer
Dockerfile example for Django
SQL
0 vote265 views1 answer
Generate a random otp in sql server
SQL
0 vote243 views1 answer
T-sql update table variale
SQL
1 vote241 views1 answer
Customer using hdfc bank sql query
SQL
0 vote224 views1 answer
Renommer base sql
SQL
0 vote236 views2 answers
While mysql
SQL
2 votes237 views1 answer
Oracle generated column
SQL
1 vote245 views1 answer
Sql server delete top 1000
SQL
0 vote189 views1 answer
Mysql date + 1 day
SQL
1 vote226 views1 answer
Oracle schema size
SQL