아래와 같은 데이타 에서
날짜별 코드별로 합을 구하려고 하는데요..
날짜 | ES | PA | CA | 총합
2003-10-01 | 231000 | 0 | 0 | 231000
이런식으로 나오게 할수 없을까요?
sc_p_date | sm_parent_id | sc_p_price ---------------------+--------------+------------ 2003-10-01 14:27:00 | ES | 33000 2003-10-01 15:47:52 | ES | 33000 2003-10-01 18:46:29 | ES | 165000 2003-10-01 18:57:36 | PA | 0 2003-10-02 03:13:15 | ES | 165000 2003-10-02 10:23:34 | PA | 0 2003-10-02 12:23:09 | ES | 165000 2003-10-02 13:39:26 | CA | 0 2003-10-03 13:00:33 | ES | 33000 2003-10-04 10:43:54 | ES | 33000 2003-10-04 11:51:54 | PA | 440000 2003-10-04 15:31:35 | PA | 132000 2003-10-06 14:54:13 | ES | 0 2003-10-06 16:33:06 | ES | 33000 2003-10-07 09:59:19 | ES | 33000 2003-10-07 10:20:00 | ES | 165000 2003-10-07 10:46:54 | CA | 110000 2003-10-07 11:53:53 | PA | 0 2003-10-07 13:05:56 | ES | 33000 2003-10-07 18:18:44 | ES | 33000 |