随笔分类 -  SQL SERVER

通过Order by按指定顺序排序
摘要:select * from t order by case name when '桔子' THEN 1 when '苹果' THEN 2 ELSE 3 END; 阅读全文
posted @ 2013-02-26 15:21 Vanessa 阅读(1380) 评论(0) 推荐(0)