我有下表:
Id Included Excluded
13235 null B,D
13235 E null
13236 null D
13237 null B,D
包含列和排除列将仅交替填充。因此,我希望将Included和Excluded列合并为Id为13235的一行。我的结果应该如下所示:
Id Included Excluded
13235 E B,D
13236 null D
13237 null B,D
如何在SQL中实现这一点?
尝试使用MAX
SELECT ID,
MAX(Included) Included,
MAX(Excluded) Excluded
FROM TableName
GROUP BY ID
- SQLFiddle演示