取最新一条记录

-- 方法1

SELECT *

  FROM TB_GATEBUS G

 WHERE (G.AUTOFAREGATENO, G.DEFINEDATE) IN

       (SELECT GB.AUTOFAREGATENO, MAX(GB.DEFINEDATE)

          FROM TB_GATEBUS GB

         GROUP BY GB.AUTOFAREGATENO)

-- 方法2

SELECT *

  FROM TB_GATEBUS G,

       (SELECT GB.AUTOFAREGATENO, MAX(GB.DEFINEDATE) DEFINEDATE

          FROM TB_GATEBUS GB

         GROUP BY GB.AUTOFAREGATENO) H

 WHERE G.AUTOFAREGATENO = H.AUTOFAREGATENO

   AND G.DEFINEDATE = H.DEFINEDATE

转载于:https://blog.51cto.com/hebinteng/1956329