This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I Have query like this in mysql :
SELECT * FROM dump_trx WHERE STATUS = '9' GROUP BY norek_debit
and result table :
id id_file norek_debit namarek_debit bank_tujuan norek_kredit namarek_kredit id_perusahaan nama_perusahaan no_ref_induk no_ref_anak no_ref_remittance jumlah deskripsi jenis_trx execute_date waktu_input STATUS
1 1 1231231231234 Oleoleole PT. BANK RAKYAT INDONESIA (Persero) 0119243940 Bambang Kentholet AB56466 Oleoleole 201606251020558510 201606251020558510 599102029244901 744,000 Sudah Meninggal SKN 06/27/2016 00:00:00 2016-06-29 13:52:15 1
2 1 1231231231111 Awawawaw PT. BANK CENTRAL ASIA Tbk. 3440230643 Taufik Savalas FA96123 Awawawaw 201606271442836643 201606271442836643 599102031278401 935,750 Sudah Meninggal SKN 06/27/2016 15:06:59 2016-06-29 13:52:15 1
3 2 0310004394105 BSKP IDR PT. PANIN BANK Tbk. 1445019971 OSMAN BING SATRIO DAN REKAN BSRE001 BRIDGESTONE SUMATRA RUBBER ESTATE 201606281127043224 201606281127043224 599102034449701 109,166,400 0599102034449701 0599102034449701 29/06/ 2016 NAMA BEDA SKN 06/29/2016 00:00:00 2016-06-29 15:00:41 9
4 2 0310004394105 BSKP IDR PT. PANIN BANK Tbk. 1445019971 OSMAN BING SATRIO DAN REKAN BSRE001 BRIDGESTONE SUMATRA RUBBER ESTATE 201606281131044719 201606281131044719 599102034449601 14,385,600 0599102034449601 0599102034449601 29/06/ 2016 NAMA BEDA SKN 06/29/2016 00:00:00 2016-06-29 15:00:41 9
5 2 0700001165104 PT MANDIRI TUNAS FINANCE BRI 1014583118 GUNTUR GUNAWAN MTFS001 PT MANDIRI TUNAS FINANCE 201606271357806362 201606280707946630 599102031923101 5,820,000 0599102031923101 0599102031923101 28/06/ 16 REK SALAH SKN 06/28/2016 00:00:00 2016-06-29 15:00:41 9
6 2 0700004445552 MANDIRI CUSTODY- CAS PT. BANK CENTRAL ASIA Tbk. 2050030248 PT BCA SEKURITAS MCCO001 MANDIRI CUSTODY- CASH OPERATION 201606281823225377 201606281823225377 799102148203101 6,000,000,000 002856 RETUR REL TRN 0799102148203101AL S Rek. sudah tutup 29/06/2016 RTGS 06/29/2016 09:50:00 2016-06-29 15:00:41 1
7 2 0700006023274 SUPREME ENERGY RAJAB PT. BANK RAKYAT INDONESIA (Persero) 1121881040001027 PT KERETEA API INDONESIA (PERSERO) SGYA001 SUPREME ENERGY RAJABASA 201606270844691760 201606270844691760 599102031905301 423,818,182 0599102031905301 0599102031905301 28/06/ 16 REK SALAH SKN 06/28/2016 07:30:43 2016-06-29 15:00:41 9
8 2 0700006493188 MINNA PADI KERATON I PT. BANK CENTRAL ASIA Tbk. 0030487915 ADIWIDJAJA MASMAN MCCO001 MANDIRI CUSTODY- CASH OPERATION 201606281056023766 201606281056023766 599102032608901 49,630,616 0599102032608901 0599102032608901 28/06/ 16 REKENING SKN 06/28/2016 11:41:38 2016-06-29 15:00:41 9
9 2 0700006879063 SUPRIMA MITRA ADIHUS PT. BANK CENTRAL ASIA Tbk. 8610016660 PT UNISIA MEDIKA FARMA SPMT001 SUPRIMA MITRA ADIHUSADA 201606281209060183 201606281312080260 599102033226001 43,660,390 RETUR REF NO.0599102033226001 ALS BUKAN UNTUK KAMI TGL280616 SKN 06/28/2016 13:12:35 2016-06-29 15:00:41 9
10 2 0700006879063 SUPRIMA MITRA ADIHUS PT. BANK OCBC NISP Tbk. 634010969798 PT SARANA MEDITAMA INTERNATIONAL SPMT001 SUPRIMA MITRA ADIHUSADA 201606281209060183 201606281312080266 599102033226401 8,465,367 0599102033226401 0599102033226401 RET LL G SDR TGL.28/06/2016 D/A.:Nomor Rekening salah SKN 06/28/2016 13:12:35 2016-06-29 15:00:41 9
11 2 0700007028991 KOMPAK ABT JTA BRI 1215010009501 Harry H KPAJ001 KOMPAK ABT JTA 201606281007003407 201606281017009472 599102032409501 1,508,000 0599102032409501 0599102032409501 28/06/ 16 REK SALAH SKN 06/28/2016 10:17:20 2016-06-29 15:00:41 9
12 2 0700085045602 HO PT. BANK PERMATA Tbk. 09815399959 PT. INSTRUMENTATION ENGINEERING -- REIN001 REKAYASA INDUSTRI 201606271428831020 201606271428831020 599102032031201 175,600,000 0599102032031201 Return LLG No Ref.05991 02032031201 TGL. 20160628Nama Beda SKN 06/28/2016 08:49:39 2016-06-29 15:00:42 9
13 2 0700095005794 MANDIRI SEKURITAS PT. BANK DANAMON INDONESIA 46766430 PT.Mandiri sekuritas QQ Patty Iranda MSEK001 MANDIRI SEKURITAS 201606241048283747 201606241048283747 599102033573801 7,172,750 0599102033573801 0599102033573801Account Number NOT FOUND SKN 06/28/2016 13:39:10 2016-06-29 15:00:42 1
14 2 1010004388433 DUAL OIL FIELD BCA 2380475360 Desiana Ekawati DOFI001 DUAL OIL FIELD 201606281630190144 201606281635191675 599102034134601 196,295,000 0599102034134601 0599102034134601 29/06/ 16 NAMA BEDA SKN 06/28/2016 16:35:35 2016-06-29 15:00:42 9
15 2 1010005495393 AF-CONSULT AB PT. BANK CIMB NIAGA TBK 2960100161009 NTC CONSULTING AA54612 AF-CONSULT AB 201606271613876525 201606271613876525 599102031559201 11,000,000 0599102031559201 REFF 0599102031559201 T GL 280616 D/A REK SALAH SKN 06/27/2016 16:16:04 2016-06-29 15:00:42 9
16 2 1020004348881 PUSAKA TRADISI IBU PT. BANK CIMB NIAGA TBK 4410100318186 Herman Riyanto PUTI001 PT Paragon Technology AND Inovation 201606271840921250 201606271840921250 599102032357801 40,000,000 0599102032357801 REFF 0599102032357801 T GL 280616 D/A ACC SALAH SKN 06/28/2016 10:24:46 2016-06-29 15:00:42 9
17 2 1020005448839 ASURANSI BINA DANA A PT.BANK RAKYAT INDONESIA (Persero) 57320101015446538 ENDANG SAPUTRA ASBA001 ASURANSI BINA DANA ARTA 201606271359807271 201606271615876888 599102031590801 280,000 0599102031590801 0599102031590801 28/06/ 16 REK SALAH SKN 06/27/2016 16:15:01 2016-06-29 15:00:42 9
18 2 1020005448839 ASURANSI BINA DANA A PT.BANK RAKYAT INDONESIA (Persero) 57320101015446538 ENDANG SAPUTRA ASBA001 ASURANSI BINA DANA ARTA 201606271359807271 201606271615876895 599102031591201 100,000 0599102031591201 0599102031591201 28/06/ 16 REK SALAH SKN 06/27/2016 16:15:01 2016-06-29 15:00:42 9
19 2 1020005872954 NUSA SATU INTI ARTHA PT Bank Maybank Indonesia 2153363194 PT WESHOP GLOBAL INDONESIA NSIA001 NUSA SATU INTI ARTHA 201606281325086819 201606281326087209 599102033548901 6,840,450 0599102033548901 0599102033548901 28/06/ 16 REKENING SKN 06/28/2016 13:26:10 2016-06-29 15:00:42 9
20 2 1020006265505 ASIA FROST PT. BANK CENTRAL ASIA Tbk. 5730329174 Topik Hidayat AB25011 ASIA FROST 201606281441128991 201606281441128991 599102033860801 1,617,000 0599102033860801 0599102033860801 29/06/ 16 NAMA BEDA SKN 06/28/2016 14:42:31 2016-06-29 15:00:42 9
21 2 1020006669995 MEDCO POWER INDONESI BANK WOORI SAUDARA INDONESIA 1906 20010111122 PT MEDCO GEOTHERMAL INDONESIA MEPO001 MEDCO POWER INDONESIA 201606271145754787 201606271145754787 599102032106901 5,000,000 0599102032106901 0599102032106901RETUR 2 8/06/2016INVALID ACCOUNT SKN 06/28/2016 08:56:46 2016-06-29 15:00:42 9
22 2 1020007757799 MANDIRI AXA GENERAL PT. BANK RAKYAT INDONESIA (Persero) 381201012015530 ISHAK M MAXA001 MANDIRI AXA GENERAL INSURANCE 201606281051021584 201606281051021584 599102032531101 1,095,000 0599102032531101 0599102032531101 28/06/ 16 NAMA BEDA SKN 06/28/2016 11:06:46 2016-06-29 15:00:42 9
23 2 1030004542359 TRI LINK INDONESIA PT. PANIN BANK Tbk. 1006513413 PT. SAMSON TIARA TRIN001 TRI LINK INDONESIA 201606281038017146 201606281038017146 599102032571301 9,500,000 0599102032571301 NO.REF : 05991020325713 01; 28/06/2016; NOMOR REKENING VALAS SKN 06/28/2016 11:26:08 2016-06-29 15:00:42 9
24 2 1030005631193 GLOBAL DIGITAL NIAGA BNI Syariah 0820555552 Mayendru Dwindra GLON001 GLOBAL DIGITAL NIAGA 201606281336092480 201606281612182325 599102034119801 100,700 0599102034119801 0599102034119801 RET LL G SDR TGL.29/06/2016 D/A.:NAMA BEDA SKN 06/28/2016 16:12:07 2016-06-29 15:00:42 9
25 2 1030006307447 OTORITAS JASA KEUANG PT. BANK CENTRAL ASIA Tbk. 4381270938 Esa Yulianto OTJK001 OTORITAS JASA KEUANGAN 201606281141047940 201606281141047940 599102033617801 5,700,000 0599102033617801 0599102033617801 28/06/ 16 REKENING SKN 06/28/2016 13:46:03 2016-06-29 15:00:42 9
26 2 1030098900000 KOPERASI PERTAMINA R PT. BANK CENTRAL ASIA Tbk. 0401935125 ANDHY WAHYUNI FA02542 KOPERASI PERTAMINA RETAIL 201606281132045295 201606281132045295 599102032772901 2,794,500 0599102032772901 0599102032772901 28/06/ 16 NAMA BEDA SKN 06/28/2016 12:14:41 2016-06-29 15:00:42 9
27 2 1040099002854 INDO PREMIER SECURIT PT. BANK MAYORA INDONESIA 600384168 SUKAMTO RAHARDJA IPSC001 INDO PREMIER SECURITIES 201606281649199499 201606281649199499 799102148186601 849,516,250 000716 RTR 0799102148186601 29062016 AL S NOREK SALAH / CLRC/5530012 RTGS 06/29/2016 00:00:00 2016-06-29 15:00:42 9
28 2 1040099002854 INDO PREMIER SECURIT PT. BANK MAYORA INDONESIA 600384168 SUKAMTO RAHARDJA IPSC001 INDO PREMIER SECURITIES 201606281704208859 201606281704208859 599102034455101 1,303,785 0599102034455101 0599102034455101 / RTR NO REKENING SALAH SKN 06/29/2016 00:00:00 2016-06-29 15:00:42 9
29 2 1040099002854 INDO PREMIER SECURIT PT. BANK RAKYAT INDONESIA (Persero) 218301000551500 SIGIT JULIUS S IPSC001 INDO PREMIER SECURITIES 201606271655889860 201606271655889860 599102031863301 37,500,000 0599102031863301 0599102031863301 28/06/ 16 NAMA BEDA SKN 06/28/2016 00:00:00 2016-06-29 15:00:43 9
30 2 1050011935578 GBI JEMAAT KEMAH DAU PT. BANK RAKYAT INDONESIA (Persero) 033601002893305 Koperasi Serba Usaha AB71371 GBI JEMAAT KEMAH DAUD 201606281059024803 201606281059024803 599102032565901 6,134,016 0599102032565901 0599102032565901 28/06/ 16 NAMA BEDA SKN 06/28/2016 11:24:03 2016-06-29 15:00:43 9
31 2 1050011935578 GBI JEMAAT KEMAH DAU PT. BANK RAKYAT INDONESIA (Persero) 033601002893305 Koperasi Serba Usaha AB71371 GBI JEMAAT KEMAH DAUD 201606281103025900 201606281103025900 599102032566301 4,704,000 0599102032566301 0599102032566301 28/06/ 16 NAMA BEDA SKN 06/28/2016 11:24:10 2016-06-29 15:00:43 9
32 2 1050012466011 YAYASAN LENTERA KASI PT. BANK CENTRAL ASIA Tbk. 2272190460 Mara Prihananto FB21258 YAYASAN LENTERA KASIH AGAPE 201606281443129723 201606281443129723 599102033866001 200,000 0599102033866001 0599102033866001 29/06/ 16 REKENING SKN 06/28/2016 14:47:27 2016-06-29 15:00:43 9
33 2 1050084001142 PEMBANGUNAN PERUMAHA PT. BANK CENTRAL ASIA Tbk. 0713022010 PT EKO POWER SYSTIM PBPM001 PEMBANGUNAN PERUMAHAN 201606281106027181 201606281106027181 599102032727101 24,990,000 0599102032727101 0599102032727101 28/06/ 16 NAMA BEDA SKN 06/28/2016 12:01:50 2016-06-29 15:00:43 9
34 2 1080005613824 NUSA PRIMA MANUNGGAL PT. BANK RAKYAT INDONESIA (Persero) 062201014564507 BRANDO SIRAIT AA15726 NUSA PRIMA MANUNGGAL 201606271357806305 201606271357806305 599102031113001 570,000 0599102031113001 0599102031113001 27/06/ 16 REK SALAH SKN 06/27/2016 14:19:32 2016-06-29 15:00:43 9
35 2 1080013246591 AWAL BROS CITRA BATA PT. BANK RAKYAT INDONESIA (Persero) 1471101912000001 ISWANDI ABCB001 AWAL BROS CITRA BATAM 201606271019724825 201606271019724825 599102032584401 4,605,000 0599102032584401 0599102032584401 28/06/ 16 REK SALAH SKN 06/28/2016 11:31:42 2016-06-29 15:00:43 9
36 2 1090091929398 HANSWAY INDONESIA PT. BANK CENTRAL ASIA Tbk. 0613079898 Helmi Bakri FA00807 HANSWAY INDONESIA 201606281451134569 201606281451134569 599102033900601 487,500 0599102033900601 0599102033900601 29/06/ 16 REKENING SKN 06/28/2016 15:11:25 2016-06-29 15:00:43 9
37 2 1100007773200 ALAM BUKIT TIGAPULUH PT. BANK CENTRAL ASIA Tbk. 09402361515 MANIMBUL L A SITORUS FB15697 ALAM BUKIT TIGAPULUH 201606281802221185 201606281802221185 599102034314701 6,850,000 0599102034314701 0599102034314701 29/06/ 16 REKENING SKN 06/28/2016 18:48:58 2016-06-29 15:00:43 9
38 2 1140004599745 SURI TANI PEMUKA PT. BANK CIMB NIAGA TBK 11230000497806 MELIYANA STPK001 SURI TANI PEMUKA 201606271513851103 201606271513851103 599102032257501 64,984,000 0599102032257501 REFF 0599102032257501 T GL 280616 D/A rek salah SKN 06/28/2016 10:05:30 2016-06-29 15:00:43 9
39 2 1140010752056 BUMI LAMPUNG MAKMUR PT. BANK RAKYAT INDONESIA (Persero) 737601006979536 ali imron BMLM001 BUMI LAMPUNG MAKMUR 201606281044019157 201606281044019157 599102032449501 199,300,000 0599102032449501 0599102032449501 28/06/ 16 REK SALAH SKN 06/28/2016 10:45:29 2016-06-29 15:00:43 9
40 2 1150001009010 HQ PAI IDR Savings PT. BANK CENTRAL ASIA Tbk. 1340781771 Yetik Puspasari PIVO001 PIVOTEL AMALGAM INDONESIA 201606281108030251 201606281108030251 599102034167701 3,750,000 0599102034167701 0599102034167701 29/06/ 16 NAMA BEDA SKN 06/28/2016 17:08:22 2016-06-29 15:00:43 9
41 2 1150001009010 HQ PAI IDR Savings PT. BANK CENTRAL ASIA Tbk. 390659971 Robin PIVO001 PIVOTEL AMALGAM INDONESIA 201606281128043747 201606281128043747 599102034168501 500,000 0599102034168501 0599102034168501 29/06/ 16 REKENING SKN 06/28/2016 17:08:40 2016-06-29 15:00:43 9
42 2 1150001009010 HQ PAI IDR Savings PT. BANK CENTRAL ASIA Tbk. 390717652 Ratna Joenita PIVO001 PIVOTEL AMALGAM INDONESIA 201606281112034758 201606281112034758 599102034167801 1,000,000 0599102034167801 0599102034167801 29/06/ 16 REKENING SKN 06/28/2016 17:08:24 2016-06-29 15:00:43 9
43 2 1150042233777 PGAS TELEKOMUNIKASI BCA 9000032304090 Heri Suwito PGAS002 PGAS TELEKOMUNIKASI NUSANTARA 201606281027013081 201606281524150023 599102033934501 200,000 0599102033934501 0599102033934501 29/06/ 16 REKENING SKN 06/28/2016 15:24:27 2016-06-29 15:00:43 9
44 2 1160097030432 PANALPINA NUSAJAYA T PT. BANK CENTRAL ASIA Tbk. 0221695875 PT FAJAR INSAN NUSANTARA PANN001 PANALPINA NUSAJAYA TRANSPORT 201606281119040550 201606281119040550 599102033849901 6,968,000 0599102033849901 0599102033849901 28/06/ 16 REKENING SKN 06/28/2016 14:38:45 2016-06-29 15:00:43 9
45 2 1170006086201 OPR IDR SI TPK-HAPAG PT. BANK MEGA Tbk. 010860011280406 PT. PENSILINDO MEDIA KREATIF SMID001 SAMUDERA INDONESIA 201606271351804053 201606271351804053 599102031255501 840,000 0599102031255501 0599102031255501-RETUR 280616-NAMA BEDA SKN 06/27/2016 14:53:14 2016-06-29 15:00:44 1
46 2 1170006500946 KARISMA BAHANA GEMIL PT. BANK RAKYAT INDONESIA (Persero) 005001118048503 Esterlita s Hartini FA08684 KARISMA BAHANA GEMILANG 201606271421825192 201606271421825192 599102031786401 6,264,000 0599102031786401 0599102031786401 28/06/ 16 NAMA BEDA SKN 06/27/2016 20:33:47 2016-06-29 15:00:44 9
47 2 1170006500946 KARISMA BAHANA GEMIL PT. BANK RAKYAT INDONESIA (Persero) 033801000247506 Christien Rasjid FA08684 KARISMA BAHANA GEMILANG 201606271415815784 201606271415815784 599102031786101 806,000 0599102031786101 0599102031786101 28/06/ 16 NAMA BEDA SKN 06/27/2016 20:33:29 2016-06-29 15:00:44 9
48 2 1170006500946 KARISMA BAHANA GEMIL PT. BANK RAKYAT INDONESIA (Persero) 07610106687535 Tiah Hayati FA08684 KARISMA BAHANA GEMILANG 201606271550864710 201606271550864710 599102031792001 394,000 0599102031792001 0599102031792001 28/06/ 16 REK SALAH SKN 06/27/2016 20:42:09 2016-06-29 15:00:44 9
49 2 1170006500946 KARISMA BAHANA GEMIL PT. BANK RAKYAT INDONESIA (Persero) 207701004821508 Herlina Wati FA08684 KARISMA BAHANA GEMILANG 201606271441836144 201606271441836144 599102031787701 224,000 0599102031787701 0599102031787701 28/06/ 16 REK SALAH SKN 06/27/2016 20:36:27 2016-06-29 15:00:44 9
50 2 1170006500946 KARISMA BAHANA GEMIL PT. BANK RAKYAT INDONESIA (Persero) 566901013117530 Hadi Safwan Rez
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(35.2, 52%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELM%3C/text%3E%3C/svg%3E)
Hi @Rizal Valry
Any other confusions about the 'Gorup By' issue?
Please don't forget to accept the answers if they helped. Your action would be helpful to other users who encounter the same issue and read this thread.
Thanks for your understanding!
Best regards,
LiHong
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(137.6, 31%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENN%3C/text%3E%3C/svg%3E)
In SQL Server and most of other RDMS you must use any kind of aggregate function for all columns which are not used in the GROUP BY clause.
So you have 2 options:
Would you believe it, you could do this in SQL Server 4.x, but it was removed in Sybase 10 and SQL Server 6.0, and rightly so, because it was complete nonsense. I recall how I swore every time when I accidently left out a column from GROUP BY and got monsterous result set instead of an error message.
LiHong may on to something when he suggests using ORDER BY. If not, please explain what effect you want the GROUP BY to have. Preferrably by posting CREATE TABLE + INSERT and the expected results.
Interestingly enough I was always picturing LiHong as a woman. Hmm, LiHong, can you please clarify if this is not too personal to ask?
Hi @Rizal Valry
I just want group by field norek_debit in sql server, same as in mysql,
Since your initial query doesn't use any aggregate functions, try replacing GROUP BY dump_trx.norek_debit with Order by dump_trx.norek_debit
Best regards,
LiHong
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.