distinct doesn't work - Mailing list pgsql-novice

From stephen
Subject distinct doesn't work
Date
Msg-id 000001c7bfe8$902f10f0$cd0b690a@tablet
Whole thread Raw
Responses Re: distinct doesn't work
Re: distinct doesn't work
List pgsql-novice

Hi

 

I am doing this:

 

SELECT distinct cc.trader_id, t.credit_card_number, t.expiry_date, t.name_on_card, sum(to_number(cc.debit_credit,'999999.99')),cc.approval_number, t.business_name  FROM credit_card_history AS cc INNER JOIN traders AS t USING (trader_id) GROUP by cc.trader_id, t.credit_card_number, t.expiry_date, t.name_on_card, cc.approval_number, t.business_name having sum(to_number(cc.debit_credit,'999999.99')) != 0

 

And I expect to get one line as I only have I trader-id in my table(s) but I get this:

 

1493 4321442143314432 09/09 two duck -200  2 Duck Trading Company

1493 4321442143314432 09/09 two duck 200 5678 2 Duck Trading Company

 

In fact I don’t actually expect to get any response as the sum should have summed to zero.

 

Does anyone know what I am doing wrong?

 

Stephen Choularton

0413 545 182

02 9999 2226

 

pgsql-novice by date:

Previous
From: Raimon Fernandez
Date:
Subject: Re: subquery with more than one column
Next
From: "stephen"
Date:
Subject: identifying last entry in a table