SQL查询特定值的数据排前面

数据表fieldname字段等于fname的值排序在前：

select * from tablename where fieldname='fname' UNION ALL
select * from tablename where fieldname<>'fname' 

或者

SELECT CASE WHEN [fieldname]='fname' THEN 0 ELSE 1 END FLAG,* FROM tablename
order by flag asc