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 vote202 views1 answer
Drop all triggers oracle
SQL
0 vote193 views1 answer
Stored procedure function relation
SQL
0 vote205 views1 answer
Postgresql get diff between two dates in Months
SQL
0 vote189 views1 answer
How to start my sql server on mac
SQL
0 vote185 views1 answer
Distinct data types in a table sql query
SQL
1 vote274 views1 answer
Top 10 rows in mysql
SQL
0 vote193 views2 answers
Sqlite unique
SQL
1 vote194 views2 answers
Mysql current user
SQL
0 vote197 views1 answer
Error: connect ECONNREFUSED 127.0.0.1:5432 at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1148:16
SQL
0 vote221 views1 answer
Varchar format not case sensitive sql
SQL