select * from fairs where iscms=0
order by case
when fair_id=28
then dateadd(year,100,fairdatei)
else fairdatei end asc
sql按日期排序並特殊id置底
最新推荐文章于 2024-03-05 16:53:13 发布
select * from fairs where iscms=0
order by case
when fair_id=28
then dateadd(year,100,fairdatei)
else fairdatei end asc