2010/06/09

CASE

CASE WHEN NM_INT_ORG_PTY = 'TOTAL'
THEN SUM(T_TRAN.QTY_ACT) OVER (PARTITION BY M_MST.ID_CAL)
ELSE T_TRAN.QTY_ACT
END AS QTY_ACT

时间： 标签：

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)