상관관계 서브쿼리

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 )

Written by@MuseKim
Muse Kim