월별 합계 구하기

ename	tdate	won(계약금액)	su(수금액)
a	20060610	10	0
b	20060611	20	20
c	20060612	30	30
d	20060613	40	0
a	20060714	50	50
b	20060722	60	60
c	20060707	74	0
d	20060730	22	22
a	20060801	56	56
b	20060821	22	0
c	20060811	33	0
d	20060822	55	55

 

select left(tdate,6) as tdate, sum(won), sum(su)
from startfragment

(조건문이 필요하면 이곳에 삽입)
group by left(tdate,6)
order by left(tdate,6)

 

[출처] 지식인 | kjm5539 (http://kin.naver.com/qna/detail.nhn?d1id=1&dirId=10205&docId=66197345&qb=bXlzcWwg7JuU67OEIO2VqeqzhA==&enc=utf8&section=kin&rank=1&search_sort=0&spq=0&pid=gYwlZF5Y7vKsscyERrNssc--509190&sid=TvwFwfMC-E4AAGTGChI)