Count data and eliminating duplication in SQL (ORACLE)

Question

i have data in this table.

..... ....

so i want the output to look like table

what is the SQL for that?

Please post data as formatted text, not screenshots. Also, what have you tried so far? — Aleksej
– Aleksej, Commented Jan 21, 2017 at 16:50
Possible duplicate of MySQL: Group By & Count Multiple Fields — krokodilko
– krokodilko, Commented Jan 21, 2017 at 16:55

Gurwinder Singh · Accepted Answer · 2017-01-21 16:50:48Z

3

Simple. GROUP BY and COUNT.

select
    customer_no,
    items,
    count(*) "COUNT"
from your_table
group by customer_no,
    items;

answered Jan 21, 2017 at 16:50

Gurwinder Singh

39.7k6 gold badges62 silver badges87 bronze badges

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

1 Answer 1