22,210
社区成员
发帖
与我相关
我的任务
分享
SELECT Udept, Uname, CASE WHEN SUM(CASE WHEN P01='OK' THEN 1 ELSE 0 END)>1 THEN 'OK' ELSE '' END AS P01, CASE WHEN SUM(CASE WHEN P02='OK' THEN 1 ELSE 0 END)>1 THEN 'OK' ELSE '' END AS P02, CASE WHEN SUM(CASE WHEN P03='OK' THEN 1 ELSE 0 END)>1 THEN 'OK' ELSE '' END AS P03
FROM UTable GROUP BY Udept, Uname