查询一列出现次数最多的值

记录

 

select parentid
  from (select parentid, count(*) c from propertytable group by parentid)
where c =
       (select max(c)
     from (select parentid, count(*) c from propertytable group by parentid));