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 vote275 views1 answer
Insufficient memory to excute the sql query
SQL
0 vote264 views1 answer
Sort by last two number sql
SQL
12 votes296 views2 answers
Find duplicates mysql column
SQL
0 vote295 views1 answer
Sql script get all stored procedures from database
SQL
6 votes272 views3 answers
Mysql first day of year
SQL
0 vote273 views2 answers
Plsql function that return a table
SQL
2 votes291 views1 answer
Oracle drop sequence if exists
SQL
0 vote306 views1 answer
Spark sql grows beyond 64 kb
SQL
0 vote320 views2 answers
Insert data mysql with cmd
SQL
1 vote315 views1 answer
Mysql last year
SQL