GROUP BY SUBSTR ON DB2

By philipz on January 23, 2009 11:37 AM | Comment | No TrackBacks

On DB2, group by substr(XXXX,1,3) is not accepted. So, by the way.

SELECT b.SUB, COUNT(*)
FROM TABLEA a JOIN
(SELECT DISTINCT SUBSTR(ID,1,1) AS SUB
FROM TABLEA) b ON SUBSTR(a.ID,1,1) = b.SUB
GROUP BY b.SUB

No TrackBacks

TrackBack URL: http://server.everfine.com.tw/blog/mt-tb.cgi/230


	Philipz學習日誌此Blog是為了將每天的學習心得、偶然的發現跟突發奇想記錄下來，並與大家分享，以免白白將突然的想法或發現隨時間淡忘掉。