show data in query oracle but not include duplicate data

Question

Can you help me, i have problem with my query. i have data like bellow :

+------------+---------+-----+ | Date | Prod_ID | Qty | +------------+---------+-----+ | 01/02/2018 | Pencil | 2 | | 01/02/2018 | pencil | 3 | | 01/02/2018 | pencil | 4 | | 01/02/2018 | book | 5 | | 01/02/2018 | ruller | 1 | +------------+---------+-----+

but my result as bellow

+------------+---------+-----+ | Date | Prod_ID | Qty | +------------+---------+-----+ | 01/02/2018 | 5 | 15 | +------------+---------+-----+

i need my result bellow

+------------+---------+-----+ | Date | Prod_ID | Qty | +------------+---------+-----+ | 01/02/2018 | 3 | 15 | +------------+---------+-----+

bellow my query script

select "date", Prod_ID, Qty, from data group by "date", Prod_ID, Qty, order by "date";

Thank You,

Barbaros Özhan · Accepted Answer · 2018-07-04 05:32:41Z

2

You can try the following:

select "date", Count(Distinct Prod_ID) as total_product_count, Sum(Qty) as qty from data group by "date" order by "date";

edited Jul 4, 2018 at 5:32

Barbaros Özhan

65.9k11 gold badges36 silver badges64 bronze badges

answered Jul 4, 2018 at 4:42

Ankur Patel

1,4338 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Fajar Jul Over a year ago

sorry i forget, i need in row Prod_ID as count. but there i found problem it count all data with duplicate

Ankur Patel Over a year ago

I edited the query according to your comment. Let me know if this helps.

Collectives™ on Stack Overflow

show data in query oracle but not include duplicate data

1 Answer 1

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Related