Search
 
SCRIPT & CODE EXAMPLE
 

SQL

how to get initials 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 :: get initial in sql 
Sql :: how to write uppercase in sql 
Sql :: How to insert data in mysql ? 
Sql :: creating table in mysql 
Sql :: default password for mysql_secure_installation in mac 
Sql :: sql update multiple columns 
Sql :: postgres order by month 
Sql :: show table mysql 
Sql :: second highest salary in sql 
Sql :: sort order on two columns sql 
Sql :: image for MSSQL Windows Docker 
Sql :: create function in sql 
Sql :: mysql community server 
Sql :: Selecting duplicates 
Sql :: convert columns to rows in sql server 
Sql :: sql select from multiple tables without join 
Sql :: pl sql search in all packages 
Sql :: update select mysql 
Sql :: insert query in sql 
Sql :: raiserror with nowait 
Sql :: postgresql newline character 
Sql :: postgresql escape single quote 
Sql :: sql remove check constraint 
Sql :: how to find total working hour in sql 
Sql :: oracle lock user 
Sql :: how to check user grant in mysql 
Sql :: mysql decimal 
Sql :: sql server update top n records 
Sql :: date in mysql 
Sql :: if else sql 
ADD CONTENT
Topic
Content
Source link
Name
9+7 =