34,594
社区成员
发帖
与我相关
我的任务
分享
select *
from
(select (case when zd_id>0 and dateadd(day, zd_days, insert_time)>getdate() then zd_id
when zd_id>0 and dateadd(day, zd_days, insert_time)<getdate() then 0
when zd_id=0 then -1
else -2
end) as 排序列, *
from [table]
)
order by 1 desc
select * from tablename order by case when dateadd(dd,zd_days,insert_time)>getdate()
then zd_id else insert_time end desc
select * from tablename order by case when dateadd(dd,zd_days,insert_time)>getdate()
then zd_id else insert_time end desc
select * from tablename order by case when dateadd(dd,zd_days,insert_time)>getdate()
then zd_id end desc
select * from tb order by
case when zd_id>0 and dateadd(dd,zd_days,insert_time)>getdate() then zd_id
when zd_id>0 and dateadd(dd,zd_days,insert_time)<getdate() then -1
when zd_id=0 then -10 end desc
select * from tb
order by
case when zd_id>0 and DATEDIFF(dd,getdate(),insert_time)>0 THEN 0 ELSE zd_id END
select * from tablename order by case when dateadd(dd,zd_days,insert_time)>getdate()
then zd_id end desc
select * from tablename order by case when dateadd(dd,zd_days,insert_time)>getdate()
then zd_id end desc
select * from tb order by case when zd_id>0 and
dateadd(dd,zd_days,insert_time)>getdate() then zd_id else -1 end desc
select * from tb order by case when zd_id>0 and
dateadd(dd,zd_days,insert_time)>getdate() then zd_id else -1 end desc
select * from tablename order by case when dateadd(dd,zd_days,insert_time)>getdate()
then zd_id desc end