How to get more duplicated record from mysql

Question

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...

sreedhar · Answer

Try this.... SELECT company_name count(*) as n FROM solution group by company_name having n>1

sreedhar · Answer

there must be problem with spaces check..

Saqi · Answer

error near having n>1