Search
 
SCRIPT & CODE EXAMPLE
 

SQL

get initial in sql

SELECT UPPER(FIRST_NAME) , LOWER(LAST_NAME) 
        , SUBSTR(FIRST_NAME , 1,1) || SUBSTR(LAST_NAME , 1,1)  AS INITIALS
FROM EMPLOYEES ; 
Comment

PREVIOUS NEXT
Code Example
Sql :: uppercase sql 
Sql :: postgres recursive function 
Sql :: add not null constraint sql server 
Sql :: sqlite3 update select 
Sql :: update in sql server table 
Sql :: alter table query sql server change column 
Sql :: mysql create user with grant privileges 
Sql :: sqlite show columns 
Sql :: clear table sql 
Sql :: how to run sql server on mac 
Sql :: create table mysql integer NOT null 
Sql :: where condition in mongodb 
Sql :: insert into without column names 
Sql :: how to tun mysql on ubunto 
Sql :: postgres how to add field created at 
Sql :: sql last time database was accessed 
Sql :: drop all triggers oracle 
Sql :: mysql if else 
Sql :: oracle list days between two dates 
Sql :: mysql disable triggers 
Sql :: postgre query date 
Sql :: python sqlite3 search 
Sql :: how to import mysql database command line 
Sql :: sql order by number not ordered 
Sql :: oracle sql unique 
Sql :: mysql alter table add column 
Sql :: oracle get foreign keys on table 
Sql :: max length found in mysql 
Sql :: sql table backup 
Sql :: sqlite update query python 
ADD CONTENT
Topic
Content
Source link
Name
8+4 =