Sql

Search

get first 3 letters in sql

SELECT FIRST_NAME ,  SUBSTR(FIRST_NAME, 1 , 3 ) , LENGTH(FIRST_NAME)
FROM EMPLOYEES ;

Comment

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

Comment

PREVIOUS	NEXT

Code Example
Sql :: sql select only time from datetime
Sql :: postgres format date in select
Sql :: postgresql where datetrunc month and year equal
Sql :: python mysql search
Sql :: group_concat order by
Sql :: alter table add column
Sql :: oracle alter table add column not null
Sql :: sysdate in sql
Sql :: create table mysql
Sql :: show all public tables postgres
Sql :: how to define a composite primary key in sql
Sql :: grant mysql
Sql :: upper and lower in oracle sql
Sql :: postgres concat_ws
Sql :: sql select divide column by number
Sql :: where clause for child record apex
Sql :: sql random number between 1000 and 9999
Sql :: oracle sessions_per_user limit
Sql :: add foreign key constraint in postgresql
Sql :: get last three characters in mysql column
Sql :: brew start postgres manual
Sql :: mysql select another database
Sql :: postgres alter table owner
Sql :: mysql delete user if exists
Sql :: what is my mysql version
Sql :: mysql update row
Sql :: Configure postgresql engine for your django application
Sql :: flask sqlalchemy filter multiple conditions
Sql :: calculate distance between two latitude longitude points sql
Sql :: load sql into mamp

Search

SQL

get first 3 letters in sql

get first 3 letters in sql

ADD CONTENT