select?Top?"?&?lnrange?&?"?ID,TITLE,FSIZE,SHOWFLAG,UPDNAME,UPDTIME,XH,dsnum?From?(select?Top?"?&?(lnRange?*?p_iUsePage)?&?"?a.ID,TITLE,FSIZE,SHOWFLAG,UPDNAME,UPDTIME,XH,(select?sum(DNUM)?from?WEBODOWN?where?FID=a.Id)?as?dsnum?from?WEBDOWN?a?"?&?strSearchLimit?&?"?order?by?xh?desc,UPDTIME?asc,Id?asc)?order?by?xh?asc,UPDTIME?desc,Id?Desc<br/>这一句我按着你的思路改成这样，<br/>select?Top?"?&?lnrange?&?"?ID,TITLE,FSIZE,SHOWFLAG,UPDNAME,UPDTIME,XH,dsnum?From?(select?Top?"?&?(lnRange?*?p_iUsePage)?&?"?a.ID,TITLE,FSIZE,SHOWFLAG,UPDNAME,UPDTIME,XH,(select?sum(DNUM)?from?WEBODOWN?where?FID=a.Id)?as?dsnum?from?WEBDOWN?a?"?&?strSearchLimit?&?"?order?by?xh?desc,UPDTIME?asc,Id?asc)?b?order?by?xh?asc,UPDTIME?desc,Id?Desc得不出正确得结果。因为已经有一个A别名了，所以后面的我加了个B
select?*?from?#<br/>union?all<br/>select?season,body,null?from<br/>(select?season,body,count(1)[num]?from?#?group?by?season,body?having?count(1)<4)a<br/>,<br/>(select?1[newnum]?union?select?2?union?select?3?union?select?4)b<br/>where?b.newnum>a.num<br/>order?by?season,body,color?desc<br/><br/>这是你回的一个帖子。能给我简单的说一下是什么意思吗？感觉这个逻辑真的很新颖。