SELECT DISTINCT data_uid, inv_no, paid FROM ( SELECT data_uid, inv_no, SUM(paid) OVER (PARTITION BY data_uid, inv_no) paid FROM the_table) WHERE paid != 0;
hth, AH aly rmb wrote: > > hi semua, > klo ada data sbb : > DATA_UID INV_NO PAID > --------------- ------------ ------ > 1 INV01 25 > 1 INV01 -25 > 1 INV02 100 > 2 INV04 30 > 2 INV05 40 > 2 INV04 -20 > > data yg di inginkan > DATA_UID INV_NO PAID > --------------- ------------ ------ > 1 INV02 100 > 2 INV04 10 > 2 INV05 40 > > Penjelasannya sbb: > klo ada 2 record yg kolom data_uid dan inv_no = sama, maka kolom paidnya > akan di kalkulasi. > klo hasil kalkulasinya = 0, maka 2 record tsb tidak akan di tampilkan, > klo hasilnya ada selisih, maka hanya 1 record yg di tampilkan dng paid > = selisihnya. > > kira* bagaimana querynya ? > thx b4. > salam/aly > > > Send instant messages to your online friends > http://uk.messenger.yahoo.com <http://uk.messenger.yahoo.com> > > [Non-text portions of this message have been removed] > >
