Differences between revisions 2 and 3
⇤ ← Revision 2 as of 2005-06-01 14:19:59 →
Size: 376
Editor: SimonHuggins
Comment:
← Revision 3 as of 2005-06-01 14:20:31 → ⇥
Size: 374
Editor: SimonHuggins
Comment:
Deletions are marked like this. Additions are marked like this.
Line 11: Line 11:
{{{
Line 12: Line 13:
[[br]] SELECT SUBSTRING(domainname FROM POSITION('.' in domainname)) FROM orders WHERE type=1) AS foo
[[br]] GROUP BY substring;		  SELECT SUBSTRING(domainname FROM POSITION('.' in domainname)) FROM orders WHERE type=1) AS foo
 GROUP BY substring;
}}}

CategoryComputingTips > SQLCompTips

SQL Tips

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

Tip 1

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.

TheEarthWiki: SQLCompTips (last edited 2008-02-19 15:39:15 by localhost)