摘要:sql select max group by 先分組選出時間最大的,然後取某個欄位出來用
SELECT * FROM (
SELECT ROW_NUMBER() OVER (ORDER BY F_ETADATE) as RID ,d.*,c.F_RMK FROM T_BK d LEFT JOIN
(
SELECT B.f_RMK,B.f_refno FROM
(SELECT f_refno, MAX(f_createdate)as f_creat
FROM t_fmsmemo
GROUP BY f_refno ) A
left join t_fmsmemo B
on (A.f_refno = B.f_refno and a.f_creat = b.f_createdate )) C
ON D.F_ID = C.F_REFNO
where F_ETDDATE > '2012-10-01' )E WHERE RID < 101