select col2,col3,count(*) from tabl1group by col2,col3请参考
select col2,col3,count(col3) from tabl1group by col3,col2
SELECT COL2,COUNT(*) WHERE COL3='100'
