感谢www.baidu.com/p/dongfanghong_1
www.cnblogs.com/woloveprogram/
觉得很好用,要记下来~
select * from table where name='D'
UNION ALL
select * from table where name<>'D'
第二法】
SELECT CASE WHEN [name]='D' THEN 0 ELSE 1 END FLAG,* FROM TABLE
order by flag asc