如图所示,怎么查出这种结果出来,也就是0116033000426对应着多少种类的fisleaf值
select count(*) from table where topbarcode = '0116033000426' group by fisleaf
SELECTtopbarcode,fisleafFROMtableNameGROUP BY topbarcodeORDER BY fisleaf