前人寫sql語法耍白痴, 欄位設定囧時可採用:
SUM(CASE WHEN REAL_DIST = 'NaN' THEN '0' ELSE REAL_DIST END) as SUM_DISTANCE
Monday, April 27, 2009
oracle sql 在SUM function裡面做過濾
Subscribe to:
Post Comments (Atom)
前人寫sql語法耍白痴, 欄位設定囧時可採用:
SUM(CASE WHEN REAL_DIST = 'NaN' THEN '0' ELSE REAL_DIST END) as SUM_DISTANCE
No comments:
Post a Comment