with x as (select substr(email_adr,instr(email_adr,'@')+1) d from owner.tablename where created_dat >= trunc(sysdate)) select 'total' domain, count(d) cnt from x union all select d, count(*) from x group by d order by 2 desc;
Wenn etwas schief geht, dann freu dich. Das sind die Geschichten die dir in Erinnerung bleiben werden
20. Juli 2016
with x as (select substr(email_adr,instr(email_adr,'@')+1) d from owner.tablename where created_dat >= trunc(sysdate)) select 'total' domain, count(d) cnt from x union all select d, count(*) from x group by d order by 2 desc;
© 2025 m@rc-lenzin
Thema von Anders Norén