34,590
社区成员
发帖
与我相关
我的任务
分享
select id ,c.ENDDATE,c.ROOTPID,c.TASKNAME
from tbs.tbs_fun_apprc c
where '990099' = c.ROOTPID group by TASKNAME order by C.ENDDATE ;
select id ,c.ENDDATE,cc.ENDDATE ,c.ROOTPID,cc.ROOTPID,c.TASKNAME,cc.TASKNAME
from tbs.tbs_fun_apprc c
INNER JOIN
(select ENDDATE,ROOTPID,TASKNAME from tbs.tbs_fun_apprc group by TASKNAME ) cc on cc.ENDDATE = c.ENDDATE
where '990099' = c.ROOTPID order by C.ENDDATE;
select ENDDATE,ROOTPID,TASKNAME from tbs.tbs_fun_apprc group by TASKNAME
Group By 一个字段,前边查3个字段,其中两个还不是聚合函数,建议你去my sql板块去,这种写法,sql server会报错、