SQL查询CASE遇上NULL怎么办?
摘要:原SQL: case userName when null THEN '空' else '有值' end, 这种写法不好使;换一种:case when userName is null THEN '空' else '有值' end,这种写法好使;
阅读全文
posted @ 2019-09-05 18:59
posted @ 2019-09-05 18:59
posted @ 2019-08-08 11:40
posted @ 2019-08-04 20:40
posted @ 2018-04-09 00:23