请问一下！

Question

下面的这两个排序怎么不一样呀！
  select top 10 barinfo.click_i,barinfo.barname_c,barinfo.autoid from  barinfo(nolock) where autoid in(
   select top 50 barinfo.autoid
   from barinfo(nolock),member_id(nolock),jobcomplist(nolock) 
   where barinfo.ownerid_i=member_id.autoid and member_id.userid_c=jobcomplist.userid_c  
  group by barinfo.autoid,jobcomplist.issuedate_d
   order by jobcomplist.issuedate_d desc)
group by barinfo.click_i,barinfo.barname_c,barinfo.autoid
select top 50 barinfo.autoid,barinfo.barname_c,barinfo.click_i,barinfo.type_c,jobcomplist.num_i
   from barinfo(nolock),member_id(nolock),jobcomplist(nolock) 
   where barinfo.ownerid_i=member_id.autoid and member_id.userid_c=jobcomplist.userid_c  
  group by barinfo.autoid,jobcomplist.issuedate_d,barinfo.barname_c,barinfo.click_i,jobcomplist.num_i,barinfo.type_c
   order by jobcomplist.issuedate_d desc可以帮我改成排序效果是一样的吗？