How to select @ from mail Id in sql server

SELECT RIGHT(Email, LEN(Email) - CHARINDEX('@', email)) Domain , COUNT(Email) EmailCount FROM dbo.email WHERE LEN(Email) > 0 GROUP BY RIGHT(Email, LEN(Email) - CHARINDEX('@', email)) ORDER BY EmailCount DESC

Mageshwaran R6y ago

Hi,

please check this link:

https://stackoverflow.com/questions/2628138/how-to-select-domain-name-from-email-address

Sanwar Ranwa7y ago

Hello

Check these Links

https://www.tutorialgateway.org/sql-extract-domain-from-email/

https://www.sqlservercentral.com/forums/topic/sql-statement-to-get-before-from-email-address

https://blog.sqlauthority.com/2011/06/18/sql-server-selecting-domain-from-email-address/