As i understand ur question if u only needs the max effective date then try this,
SELECT * FROM AutoEffectExpireData AEED where datetime = (SELECT MAX(AEED.EffectiveDate) FROM topten AutoEffectExpireData
GROUP BY clos..)Group by AEED.EffectiveDate ORDER BY AEED.EffectiveDate desc