Count Within a Count

[szeiss]

Using 10g, I have a table of report names and user names. I need to count the total number of times each report was ran and the total number of unique users that ran each of those reports. I want to show the total report count and the total unique user count.

Thanks,
SZ

 

[szeiss]

Never mind, I got it.

select report, count(report), count(distinct user)
from report_log               
having (count(distinct USER) >= 3)
group by REPORT
order by count(report) desc