我试图使用string函数子string()和charindex()获取所有电子邮件地址的域名,然后对其进行分组并计算相同域名的电子邮件数量。
My查询:
declare @SearchTerm nvarchar(1) = '@'
select substring(Email, charindex(@SearchTerm, Email) + 1, len(Email)) as [Email Domain],
count(Email) as Total
from tblResident
group by substring(Email, charindex(@SearchTe