Answers for "extract the company name from email given in employee table"

SQL
0

sql distinct email regex

/*Return distinct email domain name using regular expression*/
SELECT DISTINCT (REGEXP_SUBSTR (EMAIL_ADDR, '(@)w+[.-]w+.?w+.?w+')) 
FROM SCHEMA.TABLE_NAME;
Posted by: Guest on October-26-2020

Code answers related to "extract the company name from email given in employee table"

Code answers related to "SQL"

Browse Popular Code Answers by Language