Oracle - Count distict values of a column
- by Luciana Borela
Hi I have this table:
Reason|Area_Code|Id
x dig 1
x dig 2
y dig 3
h util 4
x dig 5
I'm trying a sql that returns:
Reason|Amount of distinct Reason|Area_code
x 3 dig
y 1 dig
h 1 util
I will use this result to plot a chart. I don´t have any ideia on how this SQL can be. Could you help me?