NULLIF

From CS Wiki
Revision as of 02:48, 11 October 2020 by 보안기사 (talk | contribs) (새 문서: * NULLIF(exp1, exp2) * exp1값과 exp2값이 동일하면 NULL을 그렇지 않으면 exp1을 반환 * CASE WHEN expr1 = expr2 THEN NULL ELSE expr1 END 분류:데이터베이스)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
  • NULLIF(exp1, exp2)
  • exp1값과 exp2값이 동일하면 NULL을 그렇지 않으면 exp1을 반환
  • CASE WHEN expr1 = expr2 THEN NULL ELSE expr1 END
Retrieved from "https://cswiki.net/index.php?title=NULLIF&oldid=25386"
Creative Commons Attribution-NonCommercial-ShareAlike
Powered by MediaWiki