SELECT (CASE
WHEN card_identification = 0 THEN
SUBSTR(id_code, 3, LENGTH(id_code))
ELSE
id_code
END ) AS id_code FROM mes_smart_card WHERE 1=1 AND productid = 'pcb_mes';
sql 语句条件选择查询 case ... when, if ..else
最新推荐文章于 2022-06-27 21:02:17 发布