简单的数据库语句问题,在线等!多谢
现有表ML里有A826字段和A001字段,A001字段全为0或者1
我想统计A826字段内容如 '53.020.20 ', '53.100 ', '91.220 '.... '67.260 '的和
语句如下
SELECT COUNT(*) AS Expr1
FROM ML
WHERE (A826 = '53.020.20 ') OR
(A826 = '53.100 ') OR
(A826 = '91.220 ') OR
(A826 = '53.060 ') OR
(A826 = '53.020.30 ') OR
(A826 = '73.100.30 ') OR
(A826 = '73.100.10 ') OR
(A826 = '73.100.40 ') OR
(A826 = '73.120 ') OR
(A826 = '73.100.20 ') OR
(A826 = '73.100.99 ') OR
(A826 = '73.12 ') OR
(A826 = '53.04 ') OR
(A826 = '25.080.50 ') OR
(A826 = '23.06 ') OR
(A826 = '91.22 ') OR
(A826 = '25.180 ') OR
(A826 = '55.200 ') OR
(A826 = '53.04 ') OR
(A826 = '53.040.30 ') OR
(A826 = '17.06 ') OR
(A826 = '13.02 ') OR
(A826 = '53.040.10 ') OR
(A826 = '23.12 ') OR
(A826 = '65.060.10 ') OR
(A826 = '65.060.20 ') OR
(A826 = '65.060.35 ') OR
(A826 = '67.26 ') OR
(A826 = '13.04 ') OR
(A826 = '13.06 ') OR
(A826 = '13.03 ') OR
(A826 = '43.160 ') OR
(A826 = '25.120.10 ') OR
(A826 = '25.080 ') OR
(A826 = '23.060 ') OR