****关于存储过程的效率*****
jett 2002-02-01 11:10:21 需要做以下的统计
select count(field1) from table where field2<100
select count(field1) from table where field2<100 and field3<100
select count(field1) from table where field2<100 and field3<100 and field4<100
一共要用3句,有没有更有效率做法