Unanswered: Select column, column, count (*) group by column, column?
At this point I'm self taught when it comes to CR. I can't say that I've taught myself much but after a week I'm getting the hang of it (been reading CR for dummies ) and have successfully created a few reports. Anyway, I simply want to look at two columns in a table, group the likes and count the results:
select famnm, appnm, count (*)
where (clusterid = 'DEFAULT' or clusterid = 'CANADA')
and famnm <> 'RUBY'
group by famnm, appnm
order by famnm, appnm
Getting the list is easy but getting them grouped and counted is the issue. I end up with a list of all the above but not grouped and with a count of one (1) for each.
I know this is simple but I'm still walking half blind. Any help would be appreciated.