November 29, 2017
SELECT A.id ,A.order_no FROM pay A WHERE A.id = ( SELECT MAX(B.id) FROM pay B WHERE A.order_no = B.order_no )