请教一条SQL语句的写法！

[lienyao8866]

请教一条sql语句的写法
select * from user
有字段a,b,c，要求优先满足 a>b and c=false 的数据排在前面，剩余的排在后面

[子陌红尘]

select
    * 
from 
    [user] 
order by 
    (case when (a>b and c=false) then 1 else 2 end) ASC

[kk19840210]

select * from [user] order by case when a>b and c=false then 1 else 0 end

[kk19840210]

select * from [user] order by case when a>b and c=false then 1 else 0 end desc

[wzy_love_sly]

select   *   from   [user]  
order by case when a> b   and   c='false' then 0 else 1 end

[JL99000]

请教一条sql语句的写法
select * from user
有字段a,b,c，要求优先满足 a> b and c=false 的数据排在前面，剩余的排在后面

---
select * from [user] order by (case when a> b and c=false then 1 else 0 end)

接分了

[free1879]

SELECT *
FROM user
ORDERY BY CASE WHEN a > b and c = 'false' THEN 0 ELSE 1 END

[lienyao8866]

真是能人多啊，菜鸟太感谢了！