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

2 votes250 views2 answers
Spring where to put the data sql
SQL
0 vote245 views1 answer
Sql server convert to guid
SQL
0 vote259 views1 answer
SQL joins in python
SQL
0 vote265 views1 answer
Command line mysql xampp
SQL
0 vote228 views2 answers
Nosqlbooster query other collection
SQL
1 vote255 views1 answer
Window function mysql
SQL
1 vote229 views1 answer
Found option without preceding group in config file: /etc/mysql/mariadb.conf.d/50-server.cnf at line: 1
SQL
5 votes255 views2 answers
Mysql create database charset utf8mb4
SQL
-1 vote237 views1 answer
Search all database tables for a value sqlserver
SQL
12 votes242 views1 answer
Psql drop column
SQL