某个sql帖子的答题

select t2.*,ch from (select vinnumber,max(channelid) ch from t_jeff group by VINNumber) t1,
  t_jeff t2 where t1.VINNumber = t2.VINNumber 
  order by ch desc,t2.ChannelID desc

题目：http://www.cnblogs.com/keguangqiang/p/4535046.html