Introduction:

As a DBA, you might come across a request where you need to extract the domain of the email address, the email address that is stored in the database table. In case you want to count the most used domain names from email addresses in any given table, you can count the number of extracted domains from Email in SQL Server as shown below.

SQL Queries could be used to extract the domain from the Email address.

Let us created table named “email_demo” –

create table (ID int, Email varchar (200));

#dbms #sql #sql-server