Oracle - Count distinct values of a column

Question

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 for 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 idea on how this SQL can be done. Could you help me?

Answer 1

Try This:

  Select Reason, Count(*) AmountOfReason, Area_Code
  From Table
  Group By Reason, Area_Code

... but this assumes that Area_Code is always determined by Reason, i.e., they are always paired, that you do not have 2 rows in yr table like

x   util   5
x    dig   6

cause if that was the case this won't work.