SQL去除重复数据

select id,OpenDate,CancelDate from Customer  where  id in (select min(id) from Customer  group by OpenDate  )   order by OpenDate desc  
posted @ 2011-06-02 08:47  coding111  阅读(...)  评论(...编辑  收藏