如何对SQL结果进行排序，但保留一些特殊结果呢？

I have a result from an SQL query that I would like to sort alphabetical, but there are a couple of commonly used results that I would like to float to the top. Is there a simple way I can achieve this either by doing clever SQL or by sorting the (asp.net) datatable once I have it filled?I have a result from an SQL query that I would