|
||
0
1
JYJF
WHERE (
(@KIND = 'Y' AND CNT > 0)
OR
(@KIND = 'N' AND CNT = 0)
OR
(@KIND = '')
)
2020-11-05 *
|
0
0
ºê·¡³¢
where cnt = case @kind when 'N' then 0 when '' then cnt when 'Y' then decode(cnt, 0, 0, cnt) end
|
|
|
¡â ÀÌÀü±Û¡ä ´ÙÀ½±Û | ¸ñ·Ïº¸±â |