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
posted @
2015-05-28 16:07
JJ.Net
阅读(193)
评论()
收藏
举报
