#pragma section-numbers off

CategoryComputingTips > SQLComp''''''Tips

== SQL Tips ==

This is more a collection of recipes than tips I guess.

=== Using substring and a sub select ===

{{{
SELECT COUNT(substring),substring FROM ( 
 SELECT SUBSTRING(domainname FROM POSITION('.' in domainname)) FROM orders WHERE type=1) AS foo
 GROUP BY substring;
}}}

Group and count domain extensions.