同一张表分类显示sql 语句

access:
SELECT *
FROM Conews
WHERE title='福建' union (select * from Conews  where title<>'福建'order by counter  )


sql:
SELECT *
FROM Conews
order by case title when '福建' then '0' else title end