SQL GROUP +MAX()函式找出重覆資料欄位最大值 ... A.S_NAME, MAX(A.REG_DATE) AS MAX_REG_DATE FROM [STUDENT1] A (NOLOCK) GROUP BY A.S_ID, A.S_NAME.
確定! 回上一頁