[SQL] SELECT id_field WHERE max (date_field) < '일부 날짜'

SELECT id_field 
  FROM tbl 
   GROUP BY id_field 
   HAVING max(date_field) < 'some date' 
   

-------------------

SELECT id_field
     , max(date_field)
       FROM tbl
       GROUP BY id_field
       HAVING max(date_field) < 'some date'
       

-------------------

사용 HAVING대신에 WHERE. HAVING그룹화 된 값의 위치와 같습니다.

출처
https://stackoverflow.com/questions/2003048