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 vote211 views2 answers
How to set global time_zone in mysql
SQL
0 vote201 views1 answer
Plpgsql if statement
SQL
0 vote207 views1 answer
Where date in datetime mysql
SQL
2 votes212 views1 answer
Postgresql left join distinct on
SQL
0 vote199 views1 answer
Mysql workbench primary key
SQL
-1 vote198 views3 answers
Update mongodb version ubuntu
SQL
2 votes188 views3 answers
How to get second highest salary in each department in sql
SQL
0 vote263 views1 answer
SQLSTATE[42000]: Syntax error or access violation: 1140 Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
SQL
0 vote204 views1 answer
Database xml sql
SQL
0 vote202 views1 answer
Mssql view column data type
SQL