你的意思是ROWNUM 是否存在 影响了结果集?SELECT l.activityarr FROM crm_lead l
WHERE l.isactive = 'Y'
AND l.ad_org_id = 1000000
AND l.docstatus = 'I'
AND l.be_starttime >= trunc(SYSDATE, 'yy')
AND l.be_starttime >= t...
不可以。详见:https://www.ibm.com/support/knowledgecenter/zh/SSEPGG_10.5.0/com.ibm.db2.luw.sql.ref.doc/doc/r0005645.html:InvocationThis statement can only be embedded in an SQL procedure. It is not an executable statement and cannot be dynamically prepa...