execute sql return rowcount[398792],sql:
select count(*) AS NUM, B.DES, A.RESULT from PREDIALRESULT AS A, JIE_RESULT_TYPE AS B where A.RESULT=B.TYPEID GROUP BY B.TYPEID
这样是有问题的,一是没有做返回条数限制,二是这个语句是错的。
要改成下面这个样子:
select RESULT,
RESULTNAME = ( SELECT DES FROM JIE_RESULT_TYPE WHERE TYPEID = A.RESULT),
NUM = count(*)
from PREDIALRESULT A
GROUP BY RESULT