Diff for "SQLCompTips" - the.earth's UK Tech wiki

Differences between revisions 2 and 6 (spanning 4 versions)

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. http://www.yipu.com.cn/shangjia/info7.html

-  ⇤ ← Revision 2 as of 2005-06-01 14:19:59 → 
  Size: 376
  Editor: SimonHuggins
  Comment:
+   ← Revision 6 as of 2005-06-10 02:52:24 → ⇥
  Size: 454
  Editor: 60
  Comment:
-Deletions are marked like this.
+Additions are marked like this.
 Line 3:
-CategoryComputingTips > SQLCompTips
+CategoryComputingTips > SQLComp''''''Tips
 Line 9:
-=== Tip 1 ===
+=== Using substring and a sub select ===
 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;
}}}
-Line 16:
+Line 18:
+http://www.yipu.com.cn/shangjia/info7.html