注册
登录
| 关键词： nbsp email substr instr lower 语句 distinct 邮件 LENGTHB LOYALTY |
Oracle统计邮件域的语句 select substr(lower(t1.email),instr(t1.email,'@',-1)) DOMAIN,COUNT(distinct t1.email) from FEG_ISU.LOYALTY_MEMBER T1 where T1.EMAIL IS NOT NULL www.2cto.com AND T1.EMAIL LIKE '%@%' AND LENGTH(t1.EMAIL)=LENGTHB(t1.EMAIL) GROUP BY substr(lower(t1.email),instr(t1.email,'@',-1)) order by 2 desc; 作者 明四 |
|
声明：文章版权归原作者所有 部分文章转自互联网 如有侵权请联系
[邮箱地址] 删除
|
