상관관계 서브쿼리

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
);