If I use count on one column as: SELECT master_project, count(master_project ) AS mycounter FROM property GROUP BY master_project
I am getting distinct rows with their counters. I want to use same for 2 columns by one query.
When I try to apply count on 2 columns as
SELECT master_project, count(master_project ) AS mycounter, project, count(project ) AS myprojectcounter
FROM property GROUP BY master_project, project
In this case I don't get my expected results where as I want to see both columns having distinct records with counters regardless of each other.