想开一个sql的随笔
1、全表有唯一性,现在要统计每条数据中指定的三个字段承办人,助理以及其他的值出现的次数;其中,每条数据中,该三个字段的值有可能重复,怎样可以避免全表扫描?
SELECT COUNT(1) CNT,CBR FROM AJ WHERE CBR <> QT AND CBR <> ZL GROUP BY CBR SELECT COUNT(1) CNT,QT FROM AJ WHERE QT <> ZL GROUP BY QT SELECT COUNT(1) CNT,ZL FROM AJ WHERE GROUP BY ZL
要是想全表扫描呢?怎么处理?
SELECT COUNT(1) CNT,CBR,ID FROM AJ GROUP BY CBR,ID SELECT COUNT(1) CNT,QT,ID FROM AJ GROUP BY QT,ID SELECT COUNT(1) CNT,ZL,ID FROM AJ GROUP BY ZL,ID
然后通过程序进行id唯一处理,进行过滤。
我不是来改变世界的