Search
 
SCRIPT & CODE EXAMPLE
 

SQL

get first 3 letter of department name in sql

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

PREVIOUS NEXT
Code Example
Sql :: login to database mysql terminal 
Sql :: Configure MYSQL to run on another port number, other than the default port 3306 ubuntu linux 
Sql :: add timestamp column to existing table t-sql 
Sql :: select first rows postgresql 
Sql :: mysql number format 
Sql :: sql alter table statement 
Sql :: mysql change primary key 
Sql :: sous requete sql 
Sql :: sql create table with datetime automatically 
Sql :: select count of distinct values sql 
Sql :: how to delete git repo locally 
Sql :: sql if null then 0 
Sql :: mysql remove user privileges 
Sql :: SELECT NUMBER OF rows for all tables oracle 
Sql :: Object of class mysqli_result could not be converted to string 
Sql :: mysql create table like 
Sql :: restore postgres database from sql file 
Sql :: oracle exceeded simultaneous sessions_per_user limit 
Sql :: oracle alter table delete column 
Sql :: id increment ms sql server 
Sql :: sql remove not null constraint 
Sql :: show data in table postgres 
Sql :: how to know the username of postgresql 
Sql :: coalesce postgresql 
Sql :: docker run postgres locally 
Sql :: delete top N rows in sql 
Sql :: random name function in mysql for nvarchar 
Sql :: mysql how to store lat,lng 
Sql :: mysql limit rows 
Sql :: permission denied postgres copy csv command line 
ADD CONTENT
Topic
Content
Source link
Name
9+9 =