Search
 
SCRIPT & CODE EXAMPLE
 

SQL

get initials name 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 :: sql server current time without date 
Sql :: lower case in sql 
Sql :: sql select date add day 
Sql :: how to find unique key in sql 
Sql :: mysql auto increment column 
Sql :: mysql random 
Sql :: sql delete duplicate rows 
Sql :: sqlite show table structure 
Sql :: sql oracle update multiple rows 
Sql :: how to pass dynamic column name in sql query 
Sql :: postgres data location 
Sql :: SQL Avoid Duplicates in INSERT INTO SELECT 
Sql :: sql alchemy or 
Sql :: t-sql check if data exists 
Sql :: How to import CSV file into a MySQL table 
Sql :: sql select where 
Sql :: creating sqeuence in oracle database 
Sql :: pl sql case 
Sql :: how to get all dates in a month in oracle 
Sql :: select odd records sql 
Sql :: sqlite commands 
Sql :: how to check which sp is running in sql server 
Sql :: truckat table mysql 
Sql :: how covert into int in maria db 
Sql :: oracle tablespace usage 
Sql :: sql case statement 
Sql :: return the number of records in a single table mysql 
Sql :: rebuild index sql server 
Sql :: multiple left join mysql 
Sql :: Import zipped mysql dumps 
ADD CONTENT
Topic
Content
Source link
Name
5+9 =