22,300
社区成员




with cte1(id,value) as
(select 1,123 union all select 2,1654 union all select 3,3542),
cte2(id,zs) as
(select 1,'dfhf' union all select 2,'sdfjytu' union all select 4,'sdfsdgdgd')
select * from cte1 join cte2 on cte1.id=cte2.id
where cte1.id in (select id from cte1 where cte1.id<>cte2.id)
SELECT t2.UserName AS 姓名,COUNT(1)AS 总分
FROM Comm_MyCollection t1
INNER JOIN Comm_User t2 ON t1.UserID=t2.ID
WHERE t2.ZZJG IN (SELECT JobID FROM Sys_Job WHERE MyFather =@MyFather)
AND t1.WhereCollect IN('Comm_Article','Course_Base') AND CreateTS-1>=@startdate AND CreateTS-1<=@enddate
GROUP BY t2.UserName
ORDER BY 总分 DESC
SELECT t2UserName AS 姓名,COUNT(1)AS 总分
FROM Comm_MyCollection t1
INNER JOIN Comm_User t2 ON t1.UserID=t2.ID
WHERE t2.ZZJG IN (SELECT JobID FROM Sys_Job WHERE MyFather =@MyFather)
AND t1.WhereCollect IN('Comm_Article','Course_Base') AND CreateTS-1>=@startdate AND CreateTS-1<=@enddate
GROUP BY t2.UserName
ORDER BY 总分 DESC