select *from User表 where UserName = 'Wang'and Type =0 order by Time desc
select * from [user] order by case when UserName = 'Wang' and Type = 0 then 1 else 0 end , time desc
select * from tbname where UserName = 'Wang'and Type =0 order by Time desc
select * from [user] order by case when UserName = 'Wang' and Type = 0 then 1 else 0,time desc
反了,应该如下: select * from [user] order by case when UserName = 'Wang' and Type = 0 then 1 else 2 end , time desc
SELECT * FROM USERS ORDER BY CASE WHEN UserName = 'Wang' AND Type = 0 THEN 0 ELSE 1 END ,TIME DESC?
掉了end select * from [user] order by case when UserName = 'Wang' and Type = 0 then 1 else 0 end,time desc
select * from [user] order by case when UserName='Wang' and Type=0 then 1 else 2 end, [Time] desc
掉了end select * from [user] order by case when UserName = 'Wang' and Type = 0 then 0 else 1 end,time desc
select * from [user] where username ='Wang' and type=0 order by time desc
select * from User表 where UserName = 'Wang'and Type =0 order by Time desc union all select * from User表 where UserName != 'Wang'and Type !=0 order by Time desc
看来理解错了。 select * from [user] order by case when username ='Wang' and type=0 then 0 else 1 end, time desc
-- 我是来蹭分的!SELECT * FROM USER ORDER BY (CASE WHEN UserName='Wang' AND TYPE=0 THEN 0 ELSE 1 END) ASC, Time desc;
哈哈 连最简单的Union all都搞忘了 我太菜了 结贴给分了
select * from [user] order by( case when UserName = 'Wang' and Type = 0 then 0 else 1 end ) , time desc
select * from User order by case when UserName = 'Wang' and Type = 0 then 0 else 1 end,Time desc
select *from User表 where UserName = 'Wang'and Type =0 order by Time desc
*
from
[user]
order by
case when UserName = 'Wang' and Type = 0 then 1 else 0,time desc
select * from [user] order by case when UserName = 'Wang' and Type = 0 then 1 else 2 end , time desc
ORDER BY
CASE WHEN UserName = 'Wang' AND Type = 0 THEN 0 ELSE 1 END ,TIME DESC?
select
*
from
[user]
order by
case when UserName = 'Wang' and Type = 0 then 1 else 0 end,time desc
from [user]
order by
case when UserName='Wang' and Type=0 then 1 else 2 end,
[Time] desc
select
*
from
[user]
order by
case when UserName = 'Wang' and Type = 0 then 0 else 1 end,time desc
select * from User表 where UserName = 'Wang'and Type =0 order by Time desc
union all
select * from User表 where UserName != 'Wang'and Type !=0 order by Time desc
select * from [user] order by case when username ='Wang' and type=0 then 0 else 1 end, time desc
-- 我是来蹭分的!SELECT * FROM USER
ORDER BY (CASE WHEN UserName='Wang' AND TYPE=0 THEN 0 ELSE 1 END) ASC, Time desc;
我太菜了
结贴给分了
select * from [user] order by( case when UserName = 'Wang' and Type = 0 then 0 else 1 end ) , time desc
order by case when UserName = 'Wang' and Type = 0 then 0 else 1 end,Time desc