求一条SQL的排序，请高手帮我想下办法

Question

select ,ApplyEndTime,PartyType,Target,a.Address,PlanTime,a.Description,Requirement,IsOver,CreatorID,ApplyStartTime 
from t_ev_party order by ??逻辑是
if (ApplyStartTime > DateTime.Now || ApplyEndTime < DateTime.Now)
        {
            return "报名准备中";
        }
        else
        {
            return "报名进行中";
        }
我想让 报名进行中在顶部显示。

Answer 1

select ApplyEndTime,PartyType,Target,a.Address,PlanTime,a.Description,Requirement,IsOver,CreatorID,ApplyStartTime  
from t_ev_party order by case when datediff(day,ApplyEndTime,getdate())=0 then 0 else 1 end
试

Answer 2

select ApplyEndTime,PartyType,Target,a.Address,PlanTime,a.Description,Requirement,IsOver,CreatorID,ApplyStartTime  
from t_ev_party 
order by case when datediff(day,ApplyEndTime,getdate())>=0 then 0 else 1 end

Answer 3

select ApplyStartTime, ApplyEndTime,PartyType,Target,a.Address,PlanTime,a.Description,Requirement,IsOver,CreatorID,ApplyStartTime  
from t_ev_party order by (case when (ApplyStartTime > DateTime.Now) or (ApplyEndTime < DateTime.Now) then 1
                           else 0 end  )

Answer 4

--时间如果以日期为准
select ,ApplyEndTime,PartyType,Target,a.Address,PlanTime,a.Description,Requirement,IsOver,CreatorID,ApplyStartTime  
from t_ev_party 
order by sign(abs(datediff(day,ApplyStartTime,Getdate())))

Answer 5

--改成秒更精确点
select ApplyEndTime,PartyType,Target,a.Address,PlanTime,a.Description,Requirement,IsOver,CreatorID,ApplyStartTime  
from t_ev_party 
order by case when datediff(ss,ApplyEndTime,getdate())>=0 then 0 else 1 end

Answer 6

select ,ApplyEndTime,PartyType,Target,a.Address,PlanTime,a.Description,Requirement,IsOver,CreatorID,ApplyStartTime
from  t_ev_party 
order by case when (ApplyStartTime > DateTime.Now || ApplyEndTime < DateTime.Now) then 1 else 0 end