tablename = solution .
in table more than 2000 records stored by various 200 companies .
i want get information of that company which have more calls.
how can i write query which i can get more duplicated company_name and count his calls..
thanks...
Loading
sreedharPosted Jun 5, 2012, 10:34 AM
SELECT company_name, count(*) as n
FROM solution
group by company_name
having n>1
sreedharPosted Jun 5, 2012, 10:49 AM
SaqiPosted Jun 5, 2012, 10:39 AM