SELECT count(*) FROM WFACTIVITYINSTANCE WHERE PROCESSINSTANCEID in (SELECT PROCESSINSTANCEID FROM WFATTRIBUTEINSTANCE WHERE (STRVALUE = '38461'))SELECT count(*) FROM WFACTIVITYINSTANCE WHERE PROCESSINSTANCEID in (SELECT PROCESSINSTANCEID FROM WFATTRIBUTEINSTANCE WHERE (STRVALUE = '38452'))SELECT count(*) FROM WFACTIVITYINSTANCE WHERE PROCESSINSTANCEID in (SELECT PROCESSINSTANCEID FROM WFATTRIBUTEINSTANCE WHERE (STRVALUE = '38442'))......需求:把这几条语句整合到一条语句,要一次性取出 从外部传过来的 STRVALUE 值对应的 count(*) 返回的结果集 要有 STRVALUE 值和 count(*) 因为要要根据 STRVALUE 值取得 count(*) SELECT count(*) as count, a.PROCESSINSTANCEID FROM WFACTIVITYINSTANCE a WHERE a.PROCESSINSTANCEID
in (SELECT PROCESSINSTANCEID FROM WFATTRIBUTEINSTANCE WHERE (STRVALUE in ('38461','38452','38442')))
group by a.PROCESSINSTANCEID我这样写得到的结果 count(*) 是正确的 但是没包含 STRVALUE 的值 在线求助 谢谢大家!
in (SELECT PROCESSINSTANCEID FROM WFATTRIBUTEINSTANCE WHERE (STRVALUE in ('38461','38452','38442')))
group by a.PROCESSINSTANCEID我这样写得到的结果 count(*) 是正确的 但是没包含 STRVALUE 的值 在线求助 谢谢大家!
FROM WFACTIVITYINSTANCE a
INNER JOIN WFATTRIBUTEINSTANCE b on a.PROCESSINSTANCEID=b.PROCESSINSTANCEID
WHERE b.STRVALUE in ('38461','38452','38442')
GROUP BY a.PROCESSINSTANCEID,b.STRVALUE
in (SELECT PROCESSINSTANCEID FROM WFATTRIBUTEINSTANCE WHERE (STRVALUE in ('38461','38452','38442')))
group by STRVALUE,a.PROCESSINSTANCEID
SELECT count(*) as count, a.PROCESSINSTANCEID ,b.STRVALUE
FROM WFACTIVITYINSTANCE a
INNER JOIN WFATTRIBUTEINSTANCE b on a.PROCESSINSTANCEID=b.PROCESSINSTANCEID
WHERE b.STRVALUE in ('38461','38452','38442')
GROUP BY b.STRVALUE,a.PROCESSINSTANCEID
FROM WFACTIVITYINSTANCE a
INNER JOIN WFATTRIBUTEINSTANCE b on a.PROCESSINSTANCEID=b.PROCESSINSTANCEID
WHERE b.STRVALUE in ('38461','38452','38442')
GROUP BY a.PROCESSINSTANCEID,b.STRVALUE