置顶不一定非要怎样,你可以这样取置顶的新闻:select top 10 * from news where flag like '%置顶%' order by created_at desc只要有新的置顶新闻顶上来,旧的自然沉下去
我以前也遇到这个问题 还发一个帖子 order by 置顶字段 desc, addtime asc;就可以了
需要以下四个字段 ontop(bit),ontopendtime(datetime),createtime(datetime),orderid(int) sql语句 select top 10 * from [tabname] where [ontop] = 1 and [ontopendtime] > getdate() order by orderid desc,createtime desc
Select case isTop when 0 then “不置顶” when 1 then “置顶” ,* from news Order by Case When istop=1 and istopendtime>getdate() then istoporder Else 9999 End ,createtime desc 知道了
from news
where flag like '%置顶%'
order by created_at desc只要有新的置顶新闻顶上来,旧的自然沉下去
ontop(bit),ontopendtime(datetime),createtime(datetime),orderid(int)
sql语句
select top 10 * from [tabname] where [ontop] = 1 and [ontopendtime] > getdate() order by orderid desc,createtime desc
Order by
Case
When istop=1 and istopendtime>getdate() then istoporder
Else 9999
End ,createtime desc
知道了