开窗函数使用及sql自行构建枚举数据用于关联
1,
1 SELECT * 2 FROM ( SELECT ROW_NUMBER() OVER ( PARTITION BY process_instance_id (区分相似数据的字段,逗号分隔) ORDER BY handle_time DESC ) AS rownum , 3 * 4 FROM dbo.workflow_trans 5 ) AS t 6 WHERE t.rownum = 1
2、
1 SELECT column1 , 2 column2 3 FROM ( SELECT '扫描件' 枚举1 , 4 '扫描件' 枚举2 , 5 '扫描件' 枚举3 , 6 '扫描件' 枚举4 7 ) tb UNPIVOT ( column2 FOR column1 IN ( 枚举1, 枚举2, 枚举3, 枚举4 ) ) t;
结果: