记录工作中 同一个字段的多个不同值

SELECT
    change_datetime,
    case WHEN change_field  = "asset_code" then change_field end   as 'change_field1',
    case WHEN change_field  = "asset_name" then change_field end   as 'change_field2',
    previous_value
FROM
    audit_trail_varchar
WHERE
    change_table_id = 10 AND new_value = "deleted" AND change_field = "asset_code" 
    OR change_field = "asset_name" 
    GROUP BY change_datetime

表：

 

 结果：