GROUP BY 之后列传行,实例
SELECT NODE_TYPE,MAX(CASE WHEN WF_ID=11 THEN WORKFLOW_NAME END),
MAX(CASE WHEN WF_ID=12 THEN WORKFLOW_NAME END),
MAX(CASE WHEN WF_ID=13 THEN WORKFLOW_NAME END)
FROM table WHERE NODE_TYPE=1 GROUP BY NODE_TYPE
GROUP BY 之后列传行
最新推荐文章于 2023-07-16 20:41:04 发布