Question

帮忙写个sql的查询语句

要求sql查询的结果数据 PK_newID 顺序为 3-1-4-2
sqlserver查询的

Answer 1

select t.* ,
case when PK_newID =3 then 1
case when PK_newID =1 then 2
case when PK_newID =4 then 3
case when PK_newID =2 then 4 end AAA
from tab t where t.PK_newID in (1,2,3,4)
order by AAA

Answer 2

语句后面加上order by NewTop desc , NewTime desc 按3-1-4-2排序，应该是先按 NewTop 字段排序，再按 NewTime 字段排序

Answer 3

select pk_newid from table order by newtop desc//如果写反了就把desc去掉试试

Answer 4

select * from ( select *,PK_newID %2 as kq from table where IsState='1') t order by t.kq,t.PK_newID

Answer 5

你最好自己加一个排序列
order by pk_newid%2 desc,pk_newid desc