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 ;
Are there any code examples left?
New code examples in category SQL
SELECT UPPER(FIRST_NAME) , LOWER(LAST_NAME)
, SUBSTR(FIRST_NAME , 1,1) || SUBSTR(LAST_NAME , 1,1) AS INITIALS
FROM EMPLOYEES ;