Question

单行子查询返回多个行

SELECT AUDITID,
AUDITTYPE,
(SELECT DOCNAME FROM SYS_DOC_LIST WHERE DOCID = Q.DOCID) AS DOCNAME,
(SELECT PROJECTNAME
FROM PROJ_PROJECTINFO
WHERE PROJECTID = Q.PROJECTID) AS PROJECTNAME,
(SELECT PHASENAME
FROM PROJ_PHASE
WHERE PHASEID = Q.PHASE
AND DELFLAG = 0) AS PHASENAME,
ISCOMMIT,
ISCHECK,
REMARK,
DOCID,
ISNODOC,
CHECKSTATUS
FROM QA_PRODUCT_AUDIT Q
WHERE PROJECTID = 2945
order by PHASE desc

问题出在 (SELECT PHASENAME
FROM PROJ_PHASE
WHERE PHASEID = Q.PHASE
AND DELFLAG = 0) AS PHASENAME
但不知是怎么导致的

Answer 1

select job,Min(sal),Max(sal) from emp Where job in ( Select job From emp Group By job Having Count(*)>=4) Group By job