select TB_RAORDER.ORDERID,TB_RAORDER.ORDERNUMBER,TB_RAORDER.ORDERDATE,ODOMETER,COSTOBJECT,ORDERSUMMARY
from TB_RAORDER inner JOIN tb_coaccount on TB_RAORDER.ORDERNUMBER=tb_coaccount.ORDERNUMBERwhereSUMMARY like'%机油%'
SELECT ORDERID, ORDERDATE,ORDERSUMMARYFROM tab t1WHERE NOT EXISTS(SELECT 1 FROM tab WHERE ORDERSUMMARY= t1.ORDERSUMMARY AND ORDERDATE> t1.ORDERDATE )即可