SELECT guarantee,CASE WHEN purchase_date IS NOT NULL
THEN purchase_date WHEN product_date IS NOT NULL
THEN product_date ELSE create_time
END AS guarantee_date
FROM bs_cmdb_base_info
sql优先级字段查询
最新推荐文章于 2024-07-17 11:05:21 发布