（1）
select * from table where name='D'
UNION ALL
select * from table where name<>'D'
（2）
SELECT CASE WHEN [name]='D' THEN 0 ELSE 1 END FLAG,* FROM TABLE
order by flag asc
SQL 把特定数据排在最前面
转载于:https://www.cnblogs.com/weimingxin/p/8012090.html
（1）
select * from table where name='D'
UNION ALL
select * from table where name<>'D'
（2）
SELECT CASE WHEN [name]='D' THEN 0 ELSE 1 END FLAG,* FROM TABLE
order by flag asc
转载于:https://www.cnblogs.com/weimingxin/p/8012090.html