我有一个表有2列创建日期和删除日期,我想有一个新的表看起来像屏幕截图,任何人知道如何做
原始数据
Creation date | Deletion date |
---|---|
2023-01-06 | 2023-01-07 |
2023-01-08 | 2023-01-08 |
我想要的是
Date | Status |
---|---|
2023-01-06 | Creation |
2023-01-07 | Creation |
2023-01-08 | Creation |
2023-01-08 | Deletion |
我有一个表有2列创建日期和删除日期,我想有一个新的表看起来像屏幕截图,任何人知道如何做
原始数据
Creation date | Deletion date |
---|---|
2023-01-06 | 2023-01-07 |
2023-01-08 | 2023-01-08 |
我想要的是
Date | Status |
---|---|
2023-01-06 | Creation |
2023-01-07 | Creation |
2023-01-08 | Creation |
2023-01-08 | Deletion |
UNION
两个这样的问题.
select creation_date as event_date, 'Creation' as status
from table_name
union all
select deletion_date, 'Deletion'
from table_name
--order by event_date, status
event_date | status |
---|---|
2023-01-06 | Creation |
2023-01-07 | Deletion |
2023-01-08 | Creation |
2023-01-08 | Deletion |