SELECT aa.*
FROM TBLTRANHIST AS aa
INNER JOIN (
  SELECT STRACCTIDNO, MAX(STRTRANDATE) AS maxTrDate
  FROM TBLTRANHIST AS bb
  GROUP BY STRACCTIDNO ) AS cc
  ON aa.STRACCTIDNO = cc.STRACCTIDNO AND aa.STRTRANDATE = cc.maxTrDate

SELECT * FROM TBLTRANHIST
WHERE STRACCTIDNO|| STRTRANDATE IN
(SELECT STRACCTIDNO|| MAX(STRTRANDATE) FROM TBLTRANHIST a group by STRACCTIDNO)

 오라클에서 되던게 안되서 헤매다가

예전에 이랬던 기억이