SELECT RIGHT(fldemail, CHARINDEX('@', fldemail)-1) as Domain ,
COUNT(fldemail) as EmailCount
FROM dbo.employee
WHERE LEN(fldemail) > 0
GROUP BY RIGHT(fldemail, CHARINDEX('@', REVERSE(fldemail))-1)
ORDER BY EmailCount DESC
SELECT RIGHT(fldemail, CHARINDEX('@', fldemail)-1) as Domain FROM dbo.employee
COUNT(fldemail) as EmailCount
FROM dbo.employee
WHERE LEN(fldemail) > 0
GROUP BY RIGHT(fldemail, CHARINDEX('@', REVERSE(fldemail))-1)
ORDER BY EmailCount DESC
SELECT RIGHT(fldemail, CHARINDEX('@', fldemail)-1) as Domain FROM dbo.employee