몰라서 질문합니다.꼭 대답해 주세요..
아래의 query가 문제가 있나요?
좀 알려주~~~
SELECT m.reserved1, m.email, m.reserved2
FROM (select reserved1, email, reserved2 FROM cert) m,
(select reserved1, MAX(reserved2) AS reserved2 FROM cert
GROUP BY reserved1) n
WHERE m.reserved1 = n.reserved1 AND m.reserved2= n.reserved2
|