baiseda 发表于 2013-1-26 14:16:13

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

记录
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));
页: [1]
查看完整版本: 查询一列出现次数最多的值