本文介绍了如何获得特定SCode的panch_Amount，Org_amount的总和？的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
PHistoryId SCode BillId Years Org_amount panch_Amount AmountPaid Panch_security Org_Security Flag PaymentMode ChequeDraftNo Bank_name Issuing_date Activate PaymentDate CrDate Zone State Uid
124 S164G NULL NULL 0 200 200 NULL NULL s Cash 30110 Y 01/11/2013 Jan 8 2014 12:45PM 3 6 2
125 S164G Select NULL 0 0 0 NULL NULL B Cash 30110 Y 01/11/2013 Jan 8 2014 12:45PM 3 6 2
126 S164G NULL NULL 0 200 200 NULL NULL s Cash 30110 Y 01/11/2013 Jan 8 2014 12:45PM 3 6 2
127 S164G Select NULL 0 0 0 NULL NULL B Cash 30110 Y 01/11/2013 Jan 8 2014 12:45PM 3 6 2
132 S164G NULL NULL 0 200 200 NULL NULL s Cash 30110 Y 01/11/2013 Jan 8 2014 12:48PM 3 6 2
133 S164G Select NULL 0 0 0 NULL NULL B Cash 30110 Y 01/11/2013 Jan 8 2014 12:48PM 3 6 2
138 S164G NULL NULL 0 200 200 NULL NULL s Cash 30110 Y 01/11/2013 Jan 8 2014 2:04PM 3 6 2
139 S164G 184 NULL 0 0 0 NULL NULL B Cash 30110 Y 01/11/2013 Jan 8 2014 2:04PM 3 6 2
140 O004S NULL NULL 0 0 0 NULL NULL s Cash 533199 Y 01/11/2013 Jan 8 2014 2:08PM 2 9 2
141 O004S 185 NULL 0 200 200 NULL NULL B Cash 533199 Y 01/11/2013 Jan 8 2014 2:08PM 2 9 2
142 S254M NULL NULL 0 0 0 NULL NULL s Cash 375915 Y 01/11/2013 Jan 8 2014 2:20PM 3 15 2
143 S254M Select NULL 0 2850 2850 NULL NULL B Cash 375915 Y 01/11/2013 Jan 8 2014 2:20PM 3 15 2
144 S201J NULL NULL 0 0 0 NULL NULL s Cash 751639 Y 01/11/2013 Jan 8 2014 2:29PM 3 6 2
145 S201J 187 NULL 0 3000 3000 NULL NULL B Cash 751639 Y 01/11/2013 Jan 8 2014 2:29PM 3 6 2
146 S067H NULL NULL 0 0 0 NULL NULL s Cash 832386 Y 01/11/2013 Jan 8 2014 2:33PM 3 10 2
147 S067H 188 NULL 0 3000 3000 NULL NULL B Cash 832386 Y 01/11/2013 Jan 8 2014 2:33PM 3 10 2
148 R016S NULL NULL 0 0 0 NULL NULL s Cash 885942 Y 01/11/2013 Jan 8 2014 2:48PM 3 6 2
149 R016S 189 NULL 0 2000 2000 NULL NULL B Cash 885942 Y 01/11/2013 Jan 8 2014 2:48PM 3 6 2
150 S012G NULL NULL 0 0 0 NULL NULL s Cash 889100 Y 01/11/2013 Jan 8 2014 2:51PM 2 9 2
151 S012G 190 NULL 0 3000 3000 NULL NULL B Cash 889100 Y 01/11/2013 Jan 8 2014 2:51PM 2 9 2
152 S327K NULL NULL 0 0 0 NULL NULL s Online Banking 963120 Y 01/11/2013 Jan 8 2014 3:12PM 4 14 2
153 S327K 191 NULL 0 4000 4000 NULL NULL B Online Banking 963120 Y 01/11/2013 Jan 8 2014 3:12PM 4 14 2
154 S508B NULL NULL 0 0 0 NULL NULL s Online Banking 936943 Y 01/11/2013 Jan 8 2014 4:21PM 3 6 2
155 S508B 192 NULL 0 735 735 NULL NULL B Online Banking 936943 Y 01/11/2013 Jan 8 2014 4:21PM 3 6 2
156 R070B NULL NULL 0 0 0 NULL NULL s Money Order 990524 Y 01/11/2013 Jan 8 2014 4:26PM 2 9 2
157 R070B 84 NULL 0 2520 2520 NULL NULL B Money Order 990524 Y 01/11/2013 Jan 8 2014 4:26PM 2 9 2
158 S158J NULL NULL 0 0 0 NULL NULL s Online Banking 55713 Y 30/11/2013 Jan 8 2014 4:49PM 3 4 2
159 S158J 194 NULL 0 500 500 NULL NULL B Online Banking 55713 Y 30/11/2013 Jan 8 2014 4:49PM 3 4 2
160 S158J NULL NULL 0 0 0 NULL NULL s Online Banking 55713 Y 04/11/2013 Jan 8 2014 4:49PM 3 4 2
161 S158J 194 NULL 0 500 500 NULL NULL B Online Banking 55713 Y 04/11/2013 Jan 8 2014 4:49PM 3 4 2
162 S127C NULL NULL 0 0 0 NULL NULL s Online Banking 278076 Y 05/11/2013 Jan 9 2014 12:56PM 2 9 2
163 S127C 197 NULL 0 1500 1500 NULL NULL B Online Banking 278076 Y 05/11/2013 Jan 9 2014 12:56PM 2 9 2
164 P005F NULL NULL 0 0 0 NULL NULL s Online Banking 69427551 Y 06/11/2013 Jan 9 2014 1:12PM 3 4 2
165 P005F 198 NULL 0 1500 1500 NULL NULL B Online Banking 69427551 Y 06/11/2013 Jan 9 2014 1:12PM 3 4 2
166 M017A NULL NULL 0 0 0 NULL NULL s Online Banking 93479 Y 06/11/2013 Jan 9 2014 1:17PM 3 12 2
167 M017A 199 NULL 0 1100 1100 NULL NULL B Online Banking 93479 Y 06/11/2013 Jan 9 2014 1:17PM 3 12 2
168 A010M NULL NULL 0 0 0 NULL NULL s Online Banking 370745 Y 06/11/2013 Jan 9 2014 2:28PM 3 6 2
169 A010M 195 NULL 0 5000 5000 NULL NULL B Online Banking 370745 Y 06/11/2013 Jan 9 2014 2:28PM 3 6 2
170 S071S NULL NULL 0 0 0 NULL NULL s Online Banking 680427 Y 06/11/2013 Jan 9 2014 2:39PM 3 4 2
171 S071S 42 NULL 0 1000 1000 NULL NULL B Online Banking 680427 Y 06/11/2013 Jan 9 2014 2:39PM 3 4 2
172 M023N NULL 0 0 0 NULL NULL s Cash Y NULL Jan 21 2014 12:20PM NULL NULL 2
173 S199N NULL 0 0 0 NULL NULL s Cash Y NULL Jan 21 2014 12:28PM NULL NULL 2
174 S210A NULL 0 0 0 NULL NULL s Cash Y NULL Jan 21 2014 12:40PM NULL NULL 2
175 S505B NULL 0 0 0 NULL NULL s Cash Y NULL Jan 21 2014 12:47PM NULL NULL 2
176 S499B NULL 0 0 0 NULL NULL s Cash Y NULL Jan 21 2014 12:52PM NULL NULL 2
177 S216A NULL 0 0 0 NULL NULL s Cash Y NULL Jan 21 2014 1:01PM NULL NULL 2
178 S089H NULL 0 0 0 NULL NULL s Cash Y NULL Jan 21 2014 1:22PM NULL NULL 2
179 S208J NULL 0 0 0 NULL NULL s Cash Y NULL Jan 21 2014 1:25PM NULL NULL 2
180 C008K NULL 0 0 0 NULL NULL s Cash Y NULL Jan 21 2014 1:28PM NULL NULL 2
181 S259M NULL 0 0 0 NULL NULL s Cash Y NULL Jan 21 2014 2:05PM NULL NULL 2
182 S191R NULL 0 0 0 NULL NULL s Cash Y NULL Jan 21 2014 2:14PM NULL NULL 2
183 S392S NULL 0 0 0 NULL NULL s Cash Y NULL Jan 21 2014 2:20PM NULL NULL 2
184 S513B NULL 0 0 0 NULL NULL s Cash Y NULL Jan 22 2014 12:31PM NULL NULL 2
185 S177G NULL 0 0 0 NULL NULL s Cash Y NULL Jan 22 2014 12:35PM NULL NULL 2
186 S091L NULL 0 0 0 NULL NULL s Cash Y NULL Jan 22 2014 12:39PM NULL NULL 2
187 M038M NULL 0 0 0 NULL NULL s Cash Y NULL Jan 22 2014 12:46PM NULL NULL 2
188 S389S NULL 0 0 0 NULL NULL s Cash Y NULL Jan 22 2014 12:55PM NULL NULL 2
189 S256M NULL 0 0 0 NULL NULL s Cash Y NULL Jan 22 2014 1:01PM NULL NULL 2
190 S152C NULL 0 0 0 NULL NULL s Cash Y NULL Jan 22 2014 3:47PM NULL NULL 2
191 S395K NULL 0 0 0 NULL NULL s Cash Y NULL Jan 22 2014 3:50PM NULL NULL 2
192 S193N NULL 0 0 0 NULL NULL s Cash Y NULL Jan 24 2014 1:53PM NULL NULL 2
193 S393S NULL 0 0 0 NULL NULL s Cash Y NULL Feb 3 2014 11:51AM NULL NULL 2
194 S042V NULL 0 0 0 NULL NULL s Cash Y NULL Feb 3 2014 12:34PM NULL NULL 2
195 S210J NULL 0 0 0 NULL NULL s Cash Y NULL Feb 4 2014 2:33PM NULL NULL 2
196 S209J NULL 0 0 0 NULL NULL s Cash Y NULL Feb 4 2014 2:41PM NULL NULL 2
197 S240M NULL 0 0 0 NULL NULL s Cash Y NULL Feb 4 2014 2:49PM NULL NULL 2
198 S211A NULL 0 0 0 NULL NULL s Cash Y NULL Feb 4 2014 2:53PM NULL NULL 2
199 S257M NULL 0 0 0 NULL NULL s Cash Y NULL Feb 4 2014 3:07PM NULL NULL 2
200 S396K NULL 0 0 0 NULL NULL s Cash Y NULL Feb 4 2014 3:14PM NULL NULL 2
201 S261M NULL 0 0 0 NULL NULL s Cash Y NULL Feb 4 2014 4:40PM NULL NULL 2
202 S260M NULL 0 0 0 NULL NULL s Cash Y NULL Feb 4 2014 4:46PM NULL NULL 2
203 M067B NULL 0 0 0 NULL NULL s Cash Y NULL Feb 5 2014 11:36AM NULL NULL 2
204 S242P NULL 0 0 0 NULL NULL s Cash Y NULL Feb 5 2014 2:12PM NULL NULL 2
205 S189R NULL 0 0 0 NULL NULL s Cash Y NULL Feb 5 2014 2:18PM NULL NULL 2
206 S498B NULL 0 0 100 NULL NULL s Cash Y NULL Feb 5 2014 2:25PM NULL NULL 2
207 S200N NULL 0 0 0 NULL NULL s Cash Y NULL Feb 6 2014 10:17AM NULL NULL 2
208 S192R NULL 0 0 100 NULL NULL s Cash Y NULL Feb 6 2014 10:20AM NULL NULL 2
209 S386S NULL 0 0 100 NULL NULL s Cash Y NULL Feb 6 2014 10:25AM NULL NULL 2
210 S114T NULL 0 0 100 NULL NULL s Cash Y NULL Feb 6 2014 10:30AM NULL NULL 2
211 S514B NULL 0 0 0 NULL NULL s Cash Y NULL Feb 6 2014 10:58AM NULL NULL 2
212 S515B NULL 0 0 100 NULL NULL s Cash Y NULL Feb 6 2014 11:03AM NULL NULL 2
213 P003I NULL 0 0 100 NULL NULL s Cash Y NULL Feb 6 2014 11:06AM NULL NULL 2
214 S240P NULL 0 0 0 NULL NULL s Cash Y NULL Feb 6 2014 11:11AM NULL NULL 2
215 S104T NULL 0 0 0 NULL NULL s Cash Y NULL Feb 6 2014 11:22AM NULL NULL 2
216 S106T NULL 0 0 100 NULL NULL s Cash Y NULL Feb 6 2014 11:24AM NULL NULL 2
217 S105T NULL 0 0 100 NULL NULL s Cash Y NULL Feb 6 2014 11:29AM NULL NULL 2
218 M022D NULL 0 0 0 NULL NULL s Cash Y NULL Feb 6 2014 11:55AM NULL NULL 2
219 M022N NULL 0 0 0 NULL NULL s Cash Y NULL Feb 6 2014 12:00PM NULL NULL 2
220 T009P NULL 0 0 0 NULL NULL s Cash Y NULL Feb 6 2014 12:02PM NULL NULL 2
221 SUB-00000001 NULL 1 M 0 NULL 20 NULL NULL NULL Cash NULL Y 11/02/2014 Feb 11 2014 4:27PM NULL NULL 2
223 D016G 733 NULL 0 300 300 NULL NULL B Money Order 0021 31/01/2013 Y 31/01/2014 Mar 1 2014 12:31PM 1 5 2
225 S179J 772 NULL 0 2000 2000 NULL NULL B Money Order 1815 31/01/2013 Y 31/01/2014 Mar 1 2014 12:49PM 1 5 2
227 S005S 747 NULL 0 270 270 NULL NULL B Money Order 1445 31/01/2013 Y 31/01/2014 Mar 1 2014 12:51PM 1 5 2
229 S239M 786 NULL 0 216 216 NULL NULL B Money Order 2850 31/01/2013 Y 31/01/2014 Mar 1 2014 12:53PM 1 5 2
250 R035M NULL NULL 0 0 0 NULL NULL s Money Order 423 24/01/2013 Y 24/01/2014 Mar 3 2014 11:18AM 1 5 2
251 R035M 743 NULL 0 196 196 NULL NULL B Money Order 423 24/01/2013 Y 24/01/2014 Mar 3 2014 11:18AM 1 5 2
252 S239M 687 NULL 0 0 0 NULL NULL s Money Order 2836 23/01/2013 Y 23/01/2014 Mar 3 2014 11:21AM 1 5 2
253 S239M 687 NULL 0 216 216 NULL NULL B Money Order 2836 23/01/2013 Y 23/01/2014 Mar 3 2014 11:21AM 1 5 2
254 R007M NULL NULL 0 0 0 NULL NULL s Money Order 0226 23/01/2013 Y 23/01/2014 Mar 3 2014 11:24AM 3 6 2
255 R007M 1096 NULL 0 230 230 NULL NULL B Money Order 0226 23/01/2013 Y 23/01/2014 Mar 3 2014 11:24AM 3 6 2
258 S174N NULL NULL 0 0 0 NULL NULL s Money Order 0973 23/01/2013 Y 23/01/2014 Mar 3 2014 11:26AM 2 9 2
259 S174N 966 NULL 0 500 500 NULL NULL B Money Order 0973 23/01/2013 Y 23/01/2014 Mar 3 2014 11:26AM 2 9 2
260 R035M 665 NULL 0 0 0 NULL NULL s Money Order 425 22/01/2013 Y 22/01/2014 Mar 3 2014 11:29AM 1 5 2
261 R035M 665 NULL 0 196 196 NULL NULL B Money Order 425 22/01/2013 Y 22/01/2014 Mar 3 2014 11:29AM 1 5 2
262 M036D NULL NULL 0 0 0 NULL NULL s Money Order 937 18/01/2013 Y 18/01/2014 Mar 3 2014 11:33AM 2 9 2
263 M036D 881 NULL 0 196 196 NULL NULL B Money Order 937 18/01/2013 Y 18/01/2014 Mar 3 2014 11:33AM 2 9 2
279 S005S NULL NULL 0 0 0 NULL NULL s Money Order 166 18/01/2013 Y 18/01/2014 Mar 4 2014 4:19PM 1 5 2
280 S005S 747 NULL 0 270 270 NULL NULL B Money Order 166 18/01/2013 Y 18/01/2014 Mar 4 2014 4:19PM 1 5 2
282 S239M NULL NULL 0 0 0 NULL NULL s Money Order 2809 15/01/2014 Y 15/01/2014 Mar 4 2014 4:24PM 1 5 2
283 S239M 786 NULL 0 216 216 NULL NULL B Money Order 2809 15/01/2014 Y 15/01/2014 Mar 4 2014 4:24PM 1 5 2
284 R007M NULL NULL 0 0 0 NULL NULL s Money Order 0205 02/01/2014 Y 02/01/2014 Mar 5 2014 10:36AM 3 6 2
285 R007M 1096 NULL 0 300 300 NULL NULL B Money Order 0205 02/01/2014 Y 02/01/2014 Mar 5 2014 10:36AM 3 6 2
286 S239M NULL NULL 0 0 0 NULL NULL s Money Order 2718 03/01/2014 Y 03/01/2014 Mar 5 2014 10:38AM 1 5 2
287 S239M 786 NULL 0 308 308 NULL NULL B Money Order 2718 03/01/2014 Y 03/01/2014 Mar 5 2014 10:38AM 1 5 2
288 Y001R NULL NULL 0 0 0 NULL NULL s Money Order 863 01/01/2014 Y 01/01/2014 Mar 5 2014 10:43AM 4 14 2
289 Y001R 857 NULL 200 0 200 NULL NULL B Money Order 863 01/01/2014 Y 01/01/2014 Mar 5 2014 10:43AM 4 14 2
290 R035M NULL NULL 0 0 0 NULL NULL s Money Order 411 06/01/2014 Y 06/01/2014 Mar 5 2014 10:46AM 1 5 2
291 R035M 743 NULL 0 196 196 NULL NULL B Money Order 411 06/01/2014 Y 06/01/2014 Mar 5 2014 10:46AM 1 5 2
293 K006H 734 NULL 0 270 270 NULL NULL s Money Order 8698 09/01/2014 Y 09/01/2014 Mar 5 2014 10:52AM 1 8 2
294 K006H 734 NULL 0 270 270 NULL NULL s Money Order 8699 09/01/2014 Y 09/01/2014 Mar 5 2014 10:53AM 1 8 2
295 K006H 734 NULL 0 270 270 NULL NULL s Money Order 8700 09/01/2014 Y 09/01/2014 Mar 5 2014 10:53AM 1 8 2
296 K006H 734 NULL 0 270 270 NULL NULL s Money Order 8725 09/01/2014 Y 09/01/2014 Mar 5 2014 10:53AM 1 8 2
297 K006H 734 NULL 0 270 270 NULL NULL s Money Order 8726 09/01/2014 Y 09/01/2014 Mar 5 2014 10:53AM 1 8 2
298 K006H 734 NULL 0 270 270 NULL NULL s Money Order 8724 09/01/2014 Y 09/01/2014 Mar 5 2014 10:53AM 1 8 2
299 K006H 734 NULL 0 270 270 NULL NULL s Money Order 8574 09/01/2014 Y 09/01/2014 Mar 5 2014 10:54AM 1 8 2
300 S005S NULL NULL 0 0 0 NULL NULL s Money Order 1633 09/01/2014 Y 09/01/2014 Mar 5 2014 10:55AM 1 5 2
301 S005S 747 NULL 0 270 270 NULL NULL B Money Order 1633 09/01/2014 Y 09/01/2014 Mar 5 2014 10:55AM 1 5 2
302 R035M NULL NULL 0 0 0 NULL NULL s Money Order 420 09/01/2014 Y 09/01/2014 Mar 5 2014 10:56AM 1 5 2
303 R035M 743 NULL 0 196 196 NULL NULL B Money Order 420 09/01/2014 Y 09/01/2014 Mar 5 2014 10:56AM 1 5 2
304 S239M NULL NULL 0 0 0 NULL NULL s Money Order 2740 11/01/2014 Y 10/01/2014 Mar 5 2014 11:02AM 1 5 2
305 S239M 786 NULL 0 216 216 NULL NULL B Money Order 2740 11/01/2014 Y 10/01/2014 Mar 5 2014 11:02AM 1 5 2
306 S239M NULL NULL 0 0 0 NULL NULL s Money Order 2797 11/01/2014 Y 10/01/2014 Mar 5 2014 11:02AM 1 5 2
308 S201A NULL NULL 0 0 0 NULL NULL s Money Order 0615 13/01/2014 Y 13/01/2014 Mar 5 2014 11:06AM 2 9 2
309 S201A Select NULL 0 2000 2000 NULL NULL B Money Order 0615 13/01/2014 Y 13/01/2014 Mar 5 2014 11:06AM 2 9 2
310 S074A NULL NULL 0 0 0 NULL NULL s Money Order 4825 13/01/2014 Y 13/01/2014 Mar 5 2014 11:10AM 1 17 2
311 S074A 754 NULL 0 1000 1000 NULL NULL B Money Order 4825 13/01/2014 Y 13/01/2014 Mar 5 2014 11:10AM 1 17 2
312 S093T NULL NULL 0 0 0 NULL NULL s Money Order 0257 13/01/2014 Y 13/01/2014 Mar 5 2014 11:12AM 4 19 2
313 S093T 832 NULL 0 400 400 NULL NULL B Money Order 0257 13/01/2014 Y 13/01/2014 Mar 5 2014 11:12AM 4 19 2
314 K006H NULL NULL 0 0 0 NULL NULL s Money Order 8655 13/01/2014 Y 13/01/2014 Mar 5 2014 11:13AM 1 8 2
315 K006H NULL NULL 0 0 0 NULL NULL s Money Order 8747 13/01/2014 Y 13/01/2014 Mar 5 2014 11:13AM 1 8 2
316 K006H NULL NULL 0 0 0 NULL NULL s Money Order 8746 13/01/2014 Y 13/01/2014 Mar 5 2014 11:13AM 1 8 2
317 K006H NULL NULL 0 0 0 NULL NULL s Money Order 8656 15/01/2014 Y 15/01/2014 Mar 5 2014 11:13AM 1 8 2
318 R035M NULL NULL 0 0 0 NULL NULL s Money Order 0425 22/01/2014 Y 22/01/2014 Mar 5 2014 11:17AM 1 5 2
319 R035M 743 NULL 0 196 196 NULL NULL B Money Order 0425 22/01/2014 Y 22/01/2014 Mar 5 2014 11:17AM 1 5 2
320 K006H NULL NULL 0 0 0 NULL NULL s Money Order 8792 24/01/2014 Y 24/01/2014 Mar 5 2014 11:20AM 1 8 2
321 K006H NULL NULL 0 0 0 NULL NULL s Money Order 8803 27/01/2014 Y 27/01/2014 Mar 5 2014 11:21AM 1 8 2
322 K006H NULL NULL 0 0 0 NULL NULL s Money Order 8802 27/01/2014 Y 27/01/2014 Mar 5 2014 11:21AM 1 8 2
323 S004Y NULL NULL 0 0 0 NULL NULL s Money Order 5374 27/01/2014 Y 27/01/2014 Mar 5 2014 11:38AM 2 13 2
324 S004Y 911 NULL 0 50 50 NULL NULL B Money Order 5374 27/01/2014 Y 27/01/2014 Mar 5 2014 11:38AM 2 13 2
325 K006H NULL NULL 0 0 0 NULL NULL s Money Order 8793 28/01/2014 Y 28/01/2014 Mar 5 2014 11:39AM 1 8 2
326 K006H NULL NULL 0 0 0 NULL NULL s Money Order 8791 28/01/2014 Y 28/01/2014 Mar 5 2014 11:39AM 1 8 2
327 S005S NULL NULL 0 0 0 NULL NULL s Money Order 1694 28/01/2014 Y 28/01/2014 Mar 5 2014 11:40AM 1 5 2
328 S005S 747 NULL 0 270 270 NULL NULL B Money Order 1694 28/01/2014 Y 28/01/2014 Mar 5 2014 11:40AM 1 5 2
329 S005S NULL NULL 0 0 0 NULL NULL s Money Order 1693 28/01/2014 Y 28/01/2014 Mar 5 2014 11:42AM 1 5 2
330 S239M NULL NULL 0 0 0 NULL NULL s Money Order 2850 28/01/2014 Y 28/01/2014 Mar 5 2014 11:43AM 1 5 2
331 S205J NULL NULL 0 0 0 NULL NULL s Online Banking M637709 NULL Y 31/01/2014 Mar 5 2014 12:04PM 3 6 2
332 S205J 1194 NULL 0 400 400 NULL NULL B Online Banking M637709 31/01/2014 Y 31/01/2014 Mar 5 2014 12:04PM 3 6 2
333 S185R NULL NULL 0 0 0 NULL NULL s Online Banking S52859068 NULL Y 31/01/2014 Mar 5 2014 12:06PM 1 7 2
334 S185R 775 NULL 0 1838 1838 NULL NULL B Online Banking S52859068 31/01/2014 Y 31/01/2014 Mar 5 2014 12:06PM 1 7 2
335 S362K NULL NULL 0 0 0 NULL NULL s Online Banking M503708 NULL Y 31/01/2014 Mar 5 2014 12:07PM 1 5 2
336 S362K 794 NULL 0 2500 2500 NULL NULL B Online Banking M503708 31/01/2014 Y 31/01/2014 Mar 5 2014 12:07PM 1 5 2
337 S090A NULL NULL 0 0 0 NULL NULL s Online Banking M162628 NULL Y 31/01/2014 Mar 5 2014 12:10PM 3 4 2
338 S090A 1258 NULL 245 3755 4000 NULL NULL B Online Banking M162628 31/01/2014 Y 31/01/2014 Mar 5 2014 12:10PM 3 4 2
339 S110T NULL NULL 0 0 0 NULL NULL s Online Banking M283799 NULL Y 31/01/2014 Mar 5 2014 12:20PM 3 16 2
340 S110T 1147 NULL 0 33000 33000 NULL NULL B Online Banking M283799 31/01/2014 Y 31/01/2014 Mar 5 2014 12:20PM 3 16 2
341 P031M NULL NULL 0 0 0 NULL NULL s Online Banking M163492 NULL Y 31/01/2014 Mar 5 2014 12:23PM 3 6 2
342 P031M 1093 NULL 0 11000 11000 NULL NULL B Online Banking M163492 31/01/2014 Y 31/01/2014 Mar 5 2014 12:23PM 3 6 2
343 S218P NULL NULL 0 0 0 NULL NULL s Online Banking S49462389 NULL Y 30/01/2014 Mar 5 2014 12:28PM 3 6 2
344 S218P 1204 NULL 0 500 500 NULL NULL B Online Banking S49462389 30/01/2014 Y 30/01/2014 Mar 5 2014 12:28PM 3 6 2
345 B004G NULL NULL 0 0 0 NULL NULL s Online Banking S49714967 NULL Y 30/01/2014 Mar 5 2014 12:30PM 3 6 2
346 B004G 1050 NULL 0 7000 7000 NULL NULL B Online Banking S49714967 30/01/2014 Y 30/01/2014 Mar 5 2014 12:30PM 3 6 2
347 S188D NULL NULL 0 0 0 NULL NULL s Online Banking S50309241 NULL Y 30/01/2014 Mar 5 2014 12:34PM 4 19 2
348 S188D 840 NULL 900 0 900 NULL NULL B Online Banking S50309241 30/01/2014 Y 30/01/2014 Mar 5 2014 12:34PM 4 19 2
349 S240M NULL NULL 0 0 0 NULL NULL s Online Banking S50602884 NULL Y 30/01/2014 Mar 5 2014 12:36PM 3 6 2
350 S240M 1209 NULL 0 1925 1925 NULL NULL B Online Banking S50602884 30/01/2014 Y 30/01/2014 Mar 5 2014 12:36PM 3 6 2
351 S143S NULL NULL 0 0 0 NULL NULL s Online Banking M398645 NULL Y 29/01/2014 Mar 5 2014 12:40PM 3 12 2
352 S143S NULL NULL 0 0 0 NULL NULL s Online Banking M398645 NULL Y 29/01/2014 Mar 5 2014 12:40PM 3 12 2
353 S143S NULL NULL 0 0 0 NULL NULL s Online Banking M398645 NULL Y 29/01/2014 Mar 5 2014 12:40PM 3 12 2
354 S143S 1158 NULL 266 147 413 NULL NULL B Online Banking M398645 30/01/2014 Y 29/01/2014 Mar 5 2014 12:40PM 3 12 2
355 S473B NULL NULL 0 0 0 NULL NULL s Online Banking M441856 NULL Y 29/01/2014 Mar 5 2014 12:42PM 3 6 2
356 S473B 1246 NULL 0 5000 5000 NULL NULL B Online Banking M441856 29/01/2014 Y 29/01/2014 Mar 5 2014 12:42PM 3 6 2
357 K010N NULL NULL 0 0 0 NULL NULL s Online Banking M507398 NULL Y 29/01/2014 Mar 5 2014 12:43PM 3 12 2
358 K010N 1077 NULL 0 1200 1200 NULL NULL B Online Banking M507398 29/01/2014 Y 29/01/2014 Mar 5 2014 12:43PM 3 12 2
359 D001C NULL NULL 0 0 0 NULL NULL s Online Banking M85711 NULL Y 28/01/2014 Mar 5 2014 12:51PM 3 12 2
360 D001C 1059 NULL 122 1228 1350 NULL NULL B Online Banking M85711 28/01/2014 Y 28/01/2014 Mar 5 2014 12:51PM 3 12 2
361 S096T NULL NULL 0 0 0 NULL NULL s Online Banking M192656 NULL Y 28/01/2014 Mar 5 2014 12:53PM 2 9 2
362 S096T 942 NULL 0 2000 2000 NULL NULL B Online Banking M192656 28/01/2014 Y 28/01/2014 Mar 5 2014 12:53PM 2 9 2
363 S243P NULL NULL 0 0 0 NULL NULL s Online Banking M345835 NULL Y 28/01/2014 Mar 5 2014 12:54PM 1 5 2
364 S243P 787 NULL 0 700 700 NULL NULL B Online Banking M345835 28/01/2014 Y 28/01/2014 Mar 5 2014 12:54PM 1 5 2
365 S208A NULL NULL 0 0 0 NULL NULL s Online Banking M134706 NULL Y 28/01/2014 Mar 5 2014 12:56PM 1 5 2
366 S208A 780 NULL 0 1000 1000 NULL NULL B Online Banking M134706 28/01/2014 Y 28/01/2014 Mar 5 2014 12:56PM 1 5 2
367 S154R NULL NULL 0 0 0 NULL NULL s Online Banking M401955 NULL Y 28/01/2014 Mar 5 2014 12:57PM 3 12 2
368 S154R 1163 NULL 0 200 200 NULL NULL B Online Banking M401955 28/01/2014 Y 28/01/2014 Mar 5 2014 12:57PM 3 12 2
369 S073K NULL NULL 0 0 0 NULL NULL s Online Banking M404268 NULL Y 28/01/2014 Mar 5 2014 12:59PM 4 19 2
370 S073K 830 NULL 0 6500 6500 NULL NULL B Online Banking M404268 28/01/2014 Y 28/01/2014 Mar 5 2014 12:59PM 4 19 2
371 S192D NULL NULL 0 0 0 NULL NULL s Online Banking M426157 NULL Y 28/01/2014 Mar 5 2014 1:00PM 3 6 2
372 S192D 1177 NULL 480 6520 7000 NULL NULL B Online Banking M426157 28/01/2014 Y 28/01/2014 Mar 5 2014 1:00PM 3 6 2
373 S142A NULL NULL 0 0 0 NULL NULL s Online Banking S44835418 NULL Y 28/01/2014 Mar 5 2014 1:02PM 3 6 2
374 S142A 1156 NULL 0 5000 5000 NULL NULL B Online Banking S44835418 28/01/2014 Y 28/01/2014 Mar 5 2014 1:02PM 3 6 2
375 S142A NULL NULL 0 0 0 NULL NULL s Online Banking S44843089 NULL Y 28/01/2014 Mar 5 2014 1:02PM 3 6 2
376 S142A 1156 NULL 0 4000 4000 NULL NULL B Online Banking S44843089 28/01/2014 Y 28/01/2014 Mar 5 2014 1:02PM 3 6 2
377 S142A NULL NULL 0 0 0 NULL NULL s Online Banking S44843089 NULL Y 28/01/2014 Mar 5 2014 1:02PM 3 6 2
378 S142A 1156 NULL 0 4000 4000 NULL NULL B Online Banking S44843089 28/01/2014 Y 28/01/2014 Mar 5 2014 1:02PM 3 6 2
379 S053P NULL NULL 0 0 0 NULL NULL s Online Banking M588244 NULL Y 28/01/2014 Mar 5 2014 1:06PM 2 3 2
380 S053P 930 NULL 0 2000 2000 NULL NULL B Online Banking M588244 28/01/2014 Y 28/01/2014 Mar 5 2014 1:06PM 2 3 2
381 P001B NULL NULL 0 0 0 NULL NULL s Online Banking M570216 NULL Y 28/01/2014 Mar 5 2014 1:07PM 2 3 2
382 P001B 891 NULL 0 1000 1000 NULL NULL B Online Banking M570216 28/01/2014 Y 28/01/2014 Mar 5 2014 1:07PM 2 3 2
383 S047F NULL NULL 0 0 0 NULL NULL s Online Banking M672655 NULL Y 28/01/2014 Mar 5 2014 1:08PM 2 3 2
384 S047F 927 NULL 0 860 860 NULL NULL B Online Banking M672655 28/01/2014 Y 28/01/2014 Mar 5 2014 1:08PM 2 3 2
385 S327K NULL NULL 0 0 0 NULL NULL s Online Banking M653336 NULL Y 28/01/2014 Mar 5 2014 1:09PM 4 14 2
386 S327K 851 NULL 4000 0 4000 NULL NULL B Online Banking M653336 28/01/2014 Y 28/01/2014 Mar 5 2014 1:09PM 4 14 2
387 S046D NULL NULL 0 0 0 NULL NULL s Online Banking S42506657 NULL Y 27/01/2014 Mar 5 2014 1:16PM 3 6 2
388 S046D 1124 NULL 0 500 500 NULL NULL B Online Banking S42506657 27/01/2014 Y 27/01/2014 Mar 5 2014 1:16PM 3 6 2
389 S136R NULL NULL 0 0 0 NULL NULL s Online Banking M216698 NULL Y 27/01/2014 Mar 5 2014 1:17PM 3 6 2
390 S136R 1154 NULL 0 1000 1000 NULL NULL B Online Banking M216698 27/01/2014 Y 27/01/2014 Mar 5 2014 1:17PM 3 6 2
391 S087H NULL NULL NULL 400 400 NULL NULL s Online Banking M401269 NULL Y 27/01/2014 Mar 5 2014 1:19PM 2 9 2
392 S087H 936 NULL 0 1600 1600 NULL NULL B Online Banking M401269 27/01/2014 Y 27/01/2014 Mar 5 2014 1:19PM 2 9 2
393 C010M 1058 NULL 0 8842 8842 NULL NULL B Online Banking M133129 27/01/2014 Y 27/01/2014 Mar 5 2014 1:21PM 3 6 2
394 S346B 1008 NULL 0 10970 10970 NULL NULL B Online Banking S41364950 27/01/2014 Y 27/01/2014 Mar 5 2014 1:23PM 2 9 2
395 S346B 1008 NULL 0 10970 10970 NULL NULL B Online Banking S41364950 27/01/2014 Y 27/01/2014 Mar 5 2014 1:26PM 2 9 2
396 S091L 940 NULL 0 440 440 NULL NULL B Online Banking M762039 27/01/2014 Y 27/01/2014 Mar 5 2014 2:06PM 2 9 2
397 S136R 1154 NULL 0 1000 1000 NULL NULL B Online Banking M477900 27/01/2014 Y 27/01/2014 Mar 5 2014 2:07PM 3 6 2
405 S074H 1133 NULL 0 1225 1225 NULL NULL B Online Banking M434761 27/01/2014 Y 27/01/2014 Mar 5 2014 2:12PM 3 10 2
406 S090L 1262 NULL 0 490 490 NULL NULL B Online Banking M388407 25/01/2014 Y 25/01/2014 Mar 5 2014 2:16PM 3 1 2
407 S161J 959 NULL 0 500 500 NULL NULL B Online Banking M277110 25/01/2014 Y 25/01/2014 Mar 5 2014 2:17PM 2 13 2
408 R006C 899 NULL 0 1000 1000 NULL NULL B Online Banking M422908 25/01/2014 Y 25/01/2014 Mar 5 2014 2:28PM 2 3 2
409 S164G 1166 NULL 0 200 200 NULL NULL B Online Banking M12834 24/01/2014 Y 24/01/2014 Mar 5 2014 2:34PM 3 6 2
410 L001S 870 NULL 0 1900 1900 NULL NULL B Online Banking S36279076 24/01/2014 Y 24/01/2014 Mar 5 2014 2:36PM 2 3 2
411 S381S 1016 NULL 0 2000 2000 NULL NULL B Online Banking S36431597 24/01/2014 Y 24/01/2014 Mar 5 2014 2:38PM 2 9 2
412 S381S 1016 NULL 0 630 630 NULL NULL B Online Banking S36425276 24/01/2014 Y 24/01/2014 Mar 5 2014 2:39PM 2 9 2
413 S501B 806 NULL 0 518 518 NULL NULL B Online Banking S36510112 24/01/2014 Y 24/01/2014 Mar 5 2014 2:40PM 1 7 2
414 S375S 1233 NULL 0 5000 5000 NULL NULL B Online Banking M307333 24/01/2014 Y 24/01/2014 Mar 5 2014 2:41PM 3 6 2
415 S205D 1193 NULL 0 1127 1127 NULL NULL B Online Banking M436045 24/01/2014 Y 24/01/2014 Mar 5 2014 2:43PM 3 1 2
416 R013U 902 NULL 0 1000 1000 NULL NULL B Money Order M589597 24/01/2014 Y 24/01/2014 Mar 5 2014 2:53PM 2 3 2
417 S236P 1207 NULL 0 1020 1020 NULL NULL B Money Order M661530 24/01/2014 Y 24/01/2014 Mar 5 2014 2:54PM 3 6 2
418 S235P 1206 NULL 0 6253 6253 NULL NULL B Money Order S34557174 23/01/2014 Y 23/01/2014 Mar 5 2014 3:05PM 3 4 2
419 S506B 1027 NULL 280 10135 10415 NULL NULL B Money Order M99024 23/01/2014 Y 23/01/2014 Mar 5 2014 3:07PM 2 9 2
420 S213B 988 NULL 0 345 345 NULL NULL B Money Order M572971 NULL 22/01/2014 Y 22/01/2014 Mar 5 2014 3:52PM 2 9 2
421 S112T 758 NULL 0 300 300 NULL NULL B Money Order M525641 NULL 22/01/2014 Y 22/01/2014 Mar 5 2014 3:53PM 1 5 2
422 S386K 1239 NULL 0 1000 1000 NULL NULL B Money Order M332702 NULL 22/01/2014 Y 22/01/2014 Mar 5 2014 3:55PM 3 6 2
423 S220P 990 NULL 0 15000 15000 NULL NULL B Money Order M246183 NULL 22/01/2014 Y 22/01/2014 Mar 5 2014 3:56PM 2 9 2
424 S188R 841 NULL 0 700 700 NULL NULL B Money Order S31692222 NULL 22/01/2014 Y 22/01/2014 Mar 5 2014 4:12PM 4 19 2
425 S248M 846 NULL 0 500 500 NULL NULL B Money Order M630118 NULL 21/01/2014 Y 21/01/2014 Mar 6 2014 10:02AM 4 19 2
426 S490B 804 NULL 0 800 800 NULL NULL B Money Order M639883 NULL 21/01/2014 Y 21/01/2014 Mar 6 2014 10:08AM 1 5 2
427 S383K 1235 NULL 142 2857 2999 NULL NULL B Money Order M546658 NULL 21/01/2014 Y 21/01/2014 Mar 6 2014 10:09AM 3 6 2
428 S394K 799 NULL 0 1452 1452 NULL NULL B Money Order M290414 NULL 21/01/2014 Y 21/01/2014 Mar 6 2014 10:11AM 1 17 2
429 S246M 1218 NULL 0 1323 1323 NULL NULL B Money Order M158452 NULL 21/01/2014 Y 21/01/2014 Mar 6 2014 10:13AM 3 6 2
430 R025J NULL NULL NULL 563 563 NULL NULL s Money Order M220397 NULL 21/01/2014 Y 21/01/2014 Mar 6 2014 10:16AM 3 15 2
431 R025J 1100 NULL 171 3265 3436 NULL NULL B Money Order M220397 NULL 21/01/2014 Y 21/01/2014 Mar 6 2014 10:16AM 3 15 2
432 S197N 978 NULL 0 3000 3000 NULL NULL B Money Order M355560 NULL 21/01/2014 Y 21/01/2014 Mar 6 2014 10:18AM 2 9 2
433 N001O 824 NULL 500 1500 2000 NULL NULL B Money Order S29849855 NULL 21/01/2014 Y 21/01/2014 Mar 6 2014 10:21AM 4 11 2
434 M021J 878 NULL 0 2500 2500 NULL NULL B Money Order M160482 NULL 20/01/2014 Y 20/01/2014 Mar 6 2014 10:26AM 2 3 2
435 R003M 1095 NULL 0 2100 2100 NULL NULL B Money Order M344567 NULL 20/01/2014 Y 20/01/2014 Mar 6 2014 10:36AM 3 6 2
436 R047S 745 NULL 0 3900 3900 NULL NULL B Money Order M417779 NULL 20/01/2014 Y 20/01/2014 Mar 6 2014 10:37AM 1 5 2
437 S482B 1024 NULL 0 22500 22500 NULL NULL B Money Order S27472629 NULL 20/01/2014 Y 20/01/2014 Mar 6 2014 10:39AM 2 3 2
438 S166N 960 NULL 0 1200 1200 NULL NULL B Money Order M559856 NULL 20/01/2014 Y 20/01/2014 Mar 6 2014 10:41AM 2 9 2
439 S018F 1113 NULL 330 1069 1399 NULL NULL B Money Order S27544268 NULL 20/01/2014 Y 20/01/2014 Mar 6 2014 10:42AM 3 6 2
440 K019B 818 NULL 0 3135 3135 NULL NULL B Money Order M84369 NULL 20/01/2014 Y 20/01/2014 Mar 6 2014 10:44AM 4 19 2
441 S398B 853 NULL 0 490 490 NULL NULL B Money Order M120864 NULL 20/01/2014 Y 20/01/2014 Mar 6 2014 10:45AM 4 19 2
442 S385K 1018 NULL 0 340 340 NULL NULL B Money Order M672030 NULL 20/01/2014 Y 20/01/2014 Mar 6 2014 10:47AM 2 3 2
443 M043K 737 NULL 0 10000 10000 NULL NULL B Money Order M681885 NULL 20/01/2014 Y 20/01/2014 Mar 6 2014 10:48AM 1 17 2
444 S040V 1121 NULL 0 600 600 NULL NULL B Money Order M739412 NULL 20/01/2014 Y 20/01/2014 Mar 6 2014 10:50AM 3 6 2
445 S067H 1129 NULL 0 4000 4000 NULL NULL B Money Order M746895 NULL 20/01/2014 Y 20/01/2014 Mar 6 2014 10:51AM 3 10 2
446 G008S 1068 NULL 220 1891 2111 NULL NULL B Money Order M232678 NULL 18/01/2014 Y 18/01/2014 Mar 6 2014 11:28AM 3 6 2
447 S127C 950 NULL 0 1400 1400 NULL NULL B Money Order M207759 NULL 18/01/2014 Y 18/01/2014 Mar 6 2014 11:30AM 2 9 2
448 S117D 834 NULL 0 1710 1710 NULL NULL B Money Order M353163 NULL 18/01/2014 Y 18/01/2014 Mar 6 2014 11:31AM 4 19 2
449 L003B 1078 NULL 0 630 630 NULL NULL B Money Order M447336 NULL 18/01/2014 Y 18/01/2014 Mar 6 2014 11:33AM 3 6 2
450 S184P 972 NULL 0 1460 1460 NULL NULL B Money Order M742151 NULL 17/01/2014 Y 17/01/2014 Mar 7 2014 10:38AM 2 3 2
451 S287K 1226 NULL 0 4000 4000 NULL NULL B Money Order M386459 NULL 17/01/2014 Y 17/01/2014 Mar 7 2014 10:40AM 3 6 2
452 S039F 1119 NULL 0 2830 2830 NULL NULL B Money Order S22772925 NULL 17/01/2014 Y 17/01/2014 Mar 7 2014 10:42AM 3 6 2
453 S149C 837 NULL 0 500 500 NULL NULL B Money Order M535677 NULL 17/01/2014 Y 17/01/2014 Mar 7 2014 10:43AM 4 21 2
454 O004S 889 NULL 0 3000 3000 NULL NULL B Money Order M392842 NULL 17/01/2014 Y 17/01/2014 Mar 7 2014 10:45AM 2 9 2
455 K010N 1077 NULL 0 1400 1400 NULL NULL B Money Order M129099 NULL 17/01/2014 Y 17/01/2014 Mar 7 2014 10:48AM 3 12 2
457 P025M 1092 NULL 314 10805 11119 NULL NULL B Money Order M25509 NULL 17/01/2014 Y 17/01/2014 Mar 7 2014 10:51AM 3 6 2
458 F001J 1065 NULL 0 1348 1348 NULL NULL B Money Order S20886008 NULL 16/01/2014 Y 16/01/2014 Mar 7 2014 10:57AM 3 6 2
459 S094C 756 NULL 0 4000 4000 NULL NULL B Money Order S20625821 NULL 16/01/2014 Y 16/01/2014 Mar 7 2014 10:59AM 1 17 2
460 R035N 744 NULL 1000 0 1000 NULL NULL B Money Order M718039 NULL 16/01/2014 Y 16/01/2014 Mar 7 2014 11:01AM 1 2 2
461 M002O 820 NULL 500 0 500 NULL NULL B Money Order M498810 NULL 16/01/2014 Y 16/01/2014 Mar 7 2014 11:25AM 4 14 2
462 S208B 781 NULL 0 9500 9500 NULL NULL B Money Order S20135294 NULL 16/01/2014 Y 16/01/2014 Mar 7 2014 11:28AM 1 8 2
463 S208B 781 NULL 500 0 500 NULL NULL B Money Order S20135294 NULL 16/01/2014 Y 16/01/2014 Mar 7 2014 11:29AM 1 8 2
465 S208B 781 NULL 500 0 500 NULL NULL B Money Order S20155806 NULL 16/01/2014 Y 16/01/2014 Mar 7 2014 11:30AM 1 8 2
466 Select 781 NULL 0 3600 3600 NULL NULL B Money Order M742148 NULL 16/01/2014 Y 16/01/2014 Mar 7 2014 11:32AM NULL NULL 2
467 S055H 1128 NULL 0 500 500 NULL NULL B Money Order M737616 NULL 15/01/2014 Y 15/01/2014 Mar 7 2014 11:40AM 3 6 2
468 B004F 1049 NULL 0 2350 2350 NULL NULL B Money Order M724785 NULL 15/01/2014 Y 15/01/2014 Mar 7 2014 11:42AM 3 6 2
469 S183D 1171 NULL 0 1000 1000 NULL NULL B Money Order M507881 NULL 15/01/2014 Y 15/01/2014 Mar 7 2014 11:43AM 3 6 2
470 S288B 850 NULL 0 400 400 NULL NULL B Money Order M606614 NULL 15/01/2014 Y 15/01/2014 Mar 7 2014 11:45AM 4 19 2
471 S151C 957 NULL 0 1700 1700 NULL NULL B Money Order S17962328 NULL 15/01/2014 Y 15/01/2014 Mar 7 2014 11:47AM 2 9 2
472 S151C 957 NULL 0 500 500 NULL NULL B Money Order S17966853 NULL 15/01/2014 Y 15/01/2014 Mar 7 2014 11:48AM 2 9 2
473 S151C 957 NULL 0 1000 1000 NULL NULL B Money Order S17971185 NULL 15/01/2014 Y 15/01/2014 Mar 7 2014 11:48AM 2 9 2
474 S261M 1225 NULL 0 2750 2750 NULL NULL B Money Order M488918 NULL 15/01/2014 Y 15/01/2014 Mar 7 2014 11:51AM 3 6 2
475 S216A 1203 NULL 0 750 750 NULL NULL B Money Order M488915 NULL 15/01/2014 Y 15/01/2014 Mar 7 2014 12:08PM 3 6 2
476 S055U 488 NULL 0 10000 10000 NULL NULL B Money Order M485454 NULL 15/01/2014 Y 15/01/2014 Mar 7 2014 12:10PM 2 9 2
477 S055H 1128 NULL 0 1500 1500 NULL NULL B Money Order S17628074 NULL 15/01/2014 Y 15/01/2014 Mar 7 2014 12:12PM 3 6 2
478 S110T 1147 NULL 0 94000 94000 NULL NULL B Money Order M177458 NULL 15/01/2014 Y 15/01/2014 Mar 7 2014 12:14PM 3 16 2
479 K010N 1077 NULL 0 600 600 NULL NULL B Money Order M89733 NULL 14/01/2014 Y 14/01/2014 Mar 7 2014 12:16PM 3 12 2
480 S093R 643 NULL 0 10000 10000 NULL NULL B Money Order M392100 NULL 13/01/2014 Y 13/01/2014 Mar 7 2014 12:18PM 1 8 2
481 S012G 917 NULL 0 3000 3000 NULL NULL B Money Order S13854569 NULL 13/01/2014 Y 13/01/2014 Mar 7 2014 12:20PM 2 9 2
482 D008R 1061 NULL 946 4484 5430 NULL NULL B Money Order M51155 NULL 13/01/2014 Y 13/01/2014 Mar 7 2014 12:23PM 3 6 2
483 S508B 1254 NULL 0 1400 1400 NULL NULL B Money Order M395669 NULL 13/01/2014 Y 13/01/2014 Mar 7 2014 12:27PM 3 6 2
484 P002V 825 NULL 0 2570 2570 NULL NULL B Money Order M497555 NULL 13/01/2014 Y 13/01/2014 Mar 7 2014 12:28PM 4 19 2
485 P030K 897 NULL 0 1500 1500 NULL NULL B Money Order M688073 NULL 10/01/2014 Y 10/01/2014 Mar 7 2014 12:31PM 2 9 2
486 S169A 963 NULL 0 1800 1800 NULL NULL B Money Order M591694 NULL 10/01/2014 Y 10/01/2014 Mar 7 2014 12:33PM 2 3 2
487 S158J 1164 NULL 1205 4795 6000 NULL NULL B Money Order M321368 NULL 09/01/2014 Y 09/01/2014 Mar 7 2014 12:35PM 3 4 2
488 K010N 1077 NULL 0 350 350 NULL NULL B Money Order M477928 NULL 09/01/2014 Y 09/01/2014 Mar 7 2014 12:36PM 3 12 2
489 K003K 1073 NULL 106 6894 7000 NULL NULL B Money Order M6150676 NULL 09/01/2014 Y 09/01/2014 Mar 7 2014 12:38PM 3 4 2
490 S493B 805 NULL 0 2500 2500 NULL NULL B Money Order M122293 NULL 09/01/2014 Y 09/01/2014 Mar 7 2014 12:40PM 1 5 2
491 B012P 864 NULL 0 1500 1500 NULL NULL B Money Order M651749 NULL 08/01/2014 Y 08/01/2014 Mar 7 2014 12:48PM 2 9 2
492 S127G 1153 NULL 0 1500 1500 NULL NULL B Money Order M562961 NULL 08/01/2014 Y 08/01/2014 Mar 7 2014 12:50PM 3 15 2
493 J003V 1071 NULL 1031 18969 20000 NULL NULL B Money Order M548396 NULL 08/01/2014 Y 08/01/2014 Mar 7 2014 12:51PM 3 6 2
495 S353K 1229 NULL 0 1000 1000 NULL NULL B Money Order M256700 NULL 08/01/2014 Y 08/01/2014 Mar 7 2014 12:55PM 3 4 2
496 S393K 1269 NULL 0 500 500 NULL NULL B Money Order M204157 NULL 08/01/2014 Y 08/01/2014 Mar 7 2014 12:59PM 3 10 2
497 S208A 780 NULL 0 1000 1000 NULL NULL B Money Order M293115 NULL 07/01/2014 Y 07/01/2014 Mar 7 2014 1:10PM 1 5 2
498 S203D 982 NULL 0 1900 1900 NULL NULL B Money Order M506440 NULL 07/01/2014 Y 07/01/2014 Mar 7 2014 1:12PM 2 9 2
499 S160K 839 NULL 0 8000 8000 NULL NULL B Money Order M385233 NULL 07/01/2014 Y 07/01/2014 Mar 7 2014 2:12PM 4 19 2
500 S166N 960 NULL 0 1500 1500 NULL NULL B Money Order M355000 NULL 07/01/2014 Y 07/01/2014 Mar 7 2014 2:13PM 2 9 2
501 S150C 761 NULL 0 1500 1500 NULL NULL B Money Order M325381 NULL 07/01/2014 Y 07/01/2014 Mar 7 2014 2:14PM 1 17 2
502 S508B 1254 NULL 0 2000 2000 NULL NULL B Money Order M53071 NULL 07/01/2014 Y 07/01/2014 Mar 7 2014 2:16PM 3 6 2
503 S035V 1118 NULL 0 600 600 NULL NULL B Money Order M53071 NULL 07/01/2014 Y 07/01/2014 Mar 7 2014 2:29PM 3 6 2
504 M017A 1081 NULL 0 1300 1300 NULL NULL B Money Order M47204 NULL 07/01/2014 Y 07/01/2014 Mar 7 2014 2:31PM 3 12 2
505 S090L 1262 NULL 0 546 546 NULL NULL B Money Order M33130 NULL 07/01/2014 Y 07/01/2014 Mar 7 2014 2:32PM 3 1 2
506 B010B 1052 NULL 363 5236 5599 NULL NULL B Money Order M401190 NULL 06/01/2014 Y 06/01/2014 Mar 7 2014 2:50PM 3 6 2
507 S050U 928 NULL 0 6000 6000 NULL NULL B Money Order M830305 NULL 06/01/2014 Y 06/01/2014 Mar 7 2014 2:53PM 2 9 2
508 S204D 985 NULL 0 3000 3000 NULL NULL B Money Order M858734 NULL 06/01/2014 Y 07/01/2014 Mar 7 2014 2:55PM 2 9 2
509 V008G 811 NULL 0 1000 1000 NULL NULL B Money Order M847836 NULL 06/01/2014 Y 06/01/2014 Mar 7 2014 3:04PM 1 5 2
510 S350S 1011 NULL 0 1400 1400 NULL NULL B Money Order M789746 NULL 06/01/2014 Y 06/01/2014 Mar 7 2014 3:08PM 2 9 2
511 S008S 1110 NULL 2000 4000 6000 NULL NULL B Money Order M528847 NULL 06/01/2014 Y 06/01/2014 Mar 7 2014 3:14PM 3 6 2
512 S033V 827 NULL 0 10000 10000 NULL NULL B Money Order M538034 NULL 06/01/2014 Y 06/01/2014 Mar 7 2014 3:19PM 4 19 2
513 S074H 1133 NULL 0 1365 1365 NULL NULL B Money Order M389883 NULL 06/01/2014 Y 06/01/2014 Mar 7 2014 3:29PM 3 10 2
514 S147K 1160 NULL 1000 1000 2000 NULL NULL B Money Order S228642 NULL 06/01/2014 Y 06/01/2014 Mar 7 2014 3:31PM 3 15 2
515 S164G 1166 NULL 0 1102 1102 NULL NULL B Money Order M48584 NULL 06/01/2014 Y 06/01/2014 Mar 7 2014 3:35PM 3 6 2
516 S390K 1240 NULL 0 367 367 NULL NULL B Money Order M400513 NULL 04/01/2014 Y 04/01/2014 Mar 7 2014 3:41PM 3 6 2
517 S036V 924 NULL 0 1400 1400 NULL NULL B Money Order S95799821 NULL 04/01/2014 Y 04/01/2014 Mar 7 2014 3:44PM 2 13 2
518 S036V 924 NULL 0 5150 5150 NULL NULL B Money Order S95799821 NULL 04/01/2014 Y 04/01/2014 Mar 7 2014 3:44PM 2 13 2
519 S036V 924 NULL 325 0 325 NULL NULL B Money Order S95799821 NULL 04/01/2014 Y 04/01/2014 Mar 7 2014 3:44PM 2 13 2
520 S036V 924 NULL 325 0 325 NULL NULL B Money Order S95799821 NULL 04/01/2014 Y 04/01/2014 Mar 7 2014 3:45PM 2 13 2
521 S036V 924 NULL 325 0 325 NULL NULL B Money Order S95799821 NULL 04/01/2014 Y 04/01/2014 Mar 7 2014 3:45PM 2 13 2
522 S036V 924 NULL 325 0 325 NULL NULL B Money Order S95799821 NULL 04/01/2014 Y 04/01/2014 Mar 7 2014 3:45PM 2 13 2
523 S036V 924 NULL 325 0 325 NULL NULL B Money Order S95799821 NULL 04/01/2014 Y 04/01/2014 Mar 7 2014 3:45PM 2 13 2
524 S036V 924 NULL 325 0 325 NULL NULL B Money Order S95799821 NULL 04/01/2014 Y 04/01/2014 Mar 7 2014 3:45PM 2 13 2
525 S148C 1161 NULL 0 13750 13750 NULL NULL B Money Order M722011 NULL 04/01/2014 Y 04/01/2014 Mar 7 2014 3:49PM 3 10 2
526 A056B 862 NULL 0 17010 17010 NULL NULL B Money Order M334237 NULL 04/01/2014 Y 04/01/2014 Mar 7 2014 3:50PM 2 3 2
527 A010M 1044 NULL 0 5000 5000 NULL NULL B Money Order M56746 NULL 04/01/2014 Y 04/01/2014 Mar 7 2014 3:52PM 3 6 2
528 S388S 797 NULL 0 10000 10000 NULL NULL B Money Order M807742 NULL 02/01/2014 Y 02/01/2014 Mar 7 2014 3:54PM 1 5 2
529 S390K 1240 NULL 0 367 367 NULL NULL B Money Order M807742 NULL 04/01/2014 Y 04/01/2014 Mar 7 2014 3:56PM 3 6 2
530 M028P 880 NULL 0 1500 1500 NULL NULL B Money Order M911813 NULL 06/01/2014 Y 06/01/2014 Mar 8 2014 10:07AM 2 9 2
531 D002P 732 NULL 0 3400 3400 NULL NULL B Money Order M531521 NULL 01/01/2014 Y 01/01/2014 Mar 8 2014 10:09AM 1 5 2
532 S071S 1131 NULL 0 1300 1300 NULL NULL B Money Order M463853 NULL 01/01/2014 Y 01/01/2014 Mar 8 2014 10:11AM 3 4 2
533 S012G 917 NULL 0 5000 5000 NULL NULL B Money Order M88609751 NULL 01/01/2014 Y 01/01/2014 Mar 8 2014 10:12AM 2 9 2
534 S023C 922 NULL 0 1090 1090 NULL NULL B Money Order S88539868 NULL 01/01/2014 Y 01/01/2014 Mar 8 2014 10:17AM 2 3 2
535 P019S 895 NULL 0 2500 2500 NULL NULL B Money Order M361418 NULL 01/01/2014 Y 01/01/2014 Mar 8 2014 10:19AM 2 3 2
536 R030A 1102 NULL 0 700 700 NULL NULL B Cash 6142 Y 04/01/2014 Mar 8 2014 12:34PM 3 1 2
537 S192N 1179 NULL 0 5000 5000 NULL NULL B Cash 6143 Y 06/01/2014 Mar 8 2014 12:38PM 3 6 2
538 S189N 1173 NULL 0 1000 1000 NULL NULL B Cash 6159 Y 07/01/2014 Mar 10 2014 11:40AM 3 1 2
539 S050U 928 NULL 0 2000 2000 NULL NULL B Cash 6171 Y 08/01/2014 Mar 10 2014 11:42AM 2 9 2
540 S099R 1263 NULL 0 630 630 NULL NULL B Cash 6187 Y 08/01/2014 Mar 10 2014 1:13PM 3 1 2
541 B004G 1050 NULL 0 2000 2000 NULL NULL B Cash 6192 Y 13/01/2014 Mar 10 2014 1:15PM 3 6 2
542 S317S 1227 NULL 0 1000 1000 NULL NULL B Cash 6193 Y 13/01/2014 Mar 10 2014 1:17PM 3 6 2
543 S393S 1265 NULL 0 750 750 NULL NULL B Cash 6204 Y 16/01/2014 Mar 10 2014 1:18PM 3 1 2
544 S102J 1264 NULL 0 220 220 NULL NULL B Cash 6222 Y 21/01/2014 Mar 10 2014 1:21PM 3 1 2
545 S393S 1265 NULL 0 500 500 NULL NULL B Cash 6259 Y 28/01/2014 Mar 10 2014 1:23PM 3 1 2
546 S317S 1227 NULL 0 1500 1500 NULL NULL B Cash 6261 Y 29/01/2014 Mar 10 2014 2:25PM 3 6 2
547 S176N 1170 NULL 0 10000 10000 NULL NULL B Cash 6265 Y 30/01/2014 Mar 10 2014 2:27PM 3 1 2
548 S176N 1170 NULL 2000 0 2000 NULL NULL B Cash 6265 Y 30/01/2014 Mar 10 2014 2:28PM 3 1 2
549 D001C 1059 NULL 0 35 35 NULL NULL B Cash 122 Y 31/01/2014 Mar 10 2014 2:29PM 3 12 2
550 S071S 1131 NULL 0 35 35 NULL NULL B Cash 123 Y 31/01/2014 Mar 10 2014 2:34PM 3 4 2
551 D002F 1060 NULL 0 28 28 NULL NULL B Cash 124 Y 31/01/2014 Mar 10 2014 2:35PM 3 6 2
552 S018F 1113 NULL 0 28 28 NULL NULL B Cash 125 Y 31/01/2014 Mar 10 2014 2:37PM 3 6 2
553 S031F 1117 NULL 0 28 28 NULL NULL B Cash 125 Y 31/01/2014 Mar 10 2014 2:38PM 3 6 2
554 M024J 879 NULL 0 28 28 NULL NULL B Cash 127 Y 31/01/2014 Mar 10 2014 2:40PM 2 9 2
555 S380K 1234 NULL 0 28 28 NULL NULL B Cash 128 Y 31/01/2014 Mar 10 2014 2:41PM 3 6 2
556 J001L 1069 NULL 0 28 28 NULL NULL B Cash 130 Y 31/01/2014 Mar 10 2014 2:44PM 3 6 2
557 S236P 1207 NULL 0 35 35 NULL NULL B Cash 131 Y 31/01/2014 Mar 10 2014 2:45PM 3 6 2
558 G008S 1068 NULL 0 63 63 NULL NULL B Cash 132 Y 31/01/2014 Mar 10 2014 2:47PM 3 6 2
559 S010V 1111 NULL 0 35 35 NULL NULL B Cash 133 Y 31/01/2014 Mar 10 2014 2:48PM 3 6 2
561 01 NULL NULL NULL 0500 NULL NULL s Cash NULL NULL Y NULL Apr 5 2014 1:07PM NULL NULL 2
562 T001 NULL NULL NULL 0 NULL NULL s Cash NULL NULL Y NULL Apr 9 2014 12:43PM NULL NULL 2
563 00999 NULL NULL NULL 56 NULL NULL s Cash NULL NULL Y NULL Apr 11 2014 3:00PM NULL NULL 2
564 F3CW3X8M NULL NULL NULL 100 NULL NULL s Cash NULL NULL Y NULL Apr 16 2014 8:01PM NULL NULL 2
565 4NI5ENA5 NULL NULL NULL 100 NULL NULL s Cash NULL NULL Y NULL Apr 16 2014 8:17PM NULL NULL 2推荐答案
SELECT SCode,SUM(panch_Amount) as 'PanchAmount',
SUM (Org_Amount) as 'OrgAmount'
From table
GROUP BY SCodeSelect SUM(panch_Amount),SUM(Org_amount) from [YourTable] Where SCode=[YourSCode]
Thanks,
Hitesh
Thanks,
Hitesh
这篇关于如何获得特定SCode的panch_Amount，Org_amount的总和？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！