统计表中一字段相同值的个数（原创）

其实很简单

select recordid,count(*) as quantity from wzgl.view_bill_materiel_request group by recordid