terimakasih semuanya ....
Awaluddin Hamid <[EMAIL PROTECTED]> wrote:
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]
>
>
Send instant messages to your online friends http://uk.messenger.yahoo.com
[Non-text portions of this message have been removed]
