max不要使用group;否者会报错

SELECT UID,DEPT_NO,MAX(MODIF_VER) AS MODIF_VER FROM DEP_S_M_EXPENSE_BUDGET GROUP BY UID,DEPT_NO;