select finish,sum(*) from table1 where finish = 1 or finish = 0 group by finish ※ 引述《joedenkidd (优质的蓝色射手)》之铭言: : Dear 版友 : select sum(*) from table1 where finish =1; //找出完成的资料 : select sum(*) from table1 where finsih =0; //找出未完成的资料 : 想请问一下,要如何将上面两个查寻合并成一个