364
Comment:
|
← Revision 8 as of 2008-02-19 15:39:15 ⇥
407
converted to 1.6 markup
|
Deletions are marked like this. | Additions are marked like this. |
Line 3: | Line 3: |
CategoryComputingTips > SQLCompTips | CategoryComputingTips > SQLComp''''''Tips |
Line 9: | Line 9: |
=== Tip 1 === | === Using substring and a sub select === |
Line 11: | Line 11: |
{{{ | |
Line 14: | Line 15: |
}}} |
CategoryComputingTips > SQLCompTips
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.