SELECT
CASE WHEN NULL <> NULL THEN 0 ELSE 1 END,
CASE WHEN NULL = NULL THEN 0 ELSE 1 END,
CASE NULL WHEN NULL THEN 0 ELSE 1 END,
CASE WHEN NULL IS NULL THEN 0 ELSE 1 END
FROM HealthRecord
永远不要试图用NULL做比较
最新推荐文章于 2023-09-15 16:53:57 发布
SELECT
CASE WHEN NULL <> NULL THEN 0 ELSE 1 END,
CASE WHEN NULL = NULL THEN 0 ELSE 1 END,
CASE NULL WHEN NULL THEN 0 ELSE 1 END,
CASE WHEN NULL IS NULL THEN 0 ELSE 1 END
FROM HealthRecord