select
    size_desc
from
    ODS_INPT_ITEM_MASTER
group BY
    CREATE_DATE_TIME
having
    max(CREATE_DATE_TIME)

having max(CREATE_DATE_TIME) > '2016-07-01'

select size_desc, max(CREATE_DATE_TIME) as MaxDate
from ODS_INPT_ITEM_MASTERsize_desc
group by size_desc