 ORDER BY price
GO
这是 CASE 的典型用法，但是使用 CASE 其实可以做更多的事情。比方说下面的 GROUP BY 子句中的 CASE：
SELECT ''''Number of Titles'''', Count(*)
FROM titles
GROUP BY
CASE
WHEN price IS NULL THEN ''''Unpriced''''
WHEN price < 10 THEN ''''Bargain''''
WHEN price BETWEEN 10 and 20 THEN ''''Average''''
ELSE ''''Gift to impress relatives''''
END
GO
你甚至还可以组合这些选项，添加一个 ORDER BY 子句，如下所示：
USE pubs
GO
SELECT
CASE
WHEN price IS NULL THEN ''''Unpriced''''
WHEN price < 10 THEN ''''上一页 [1] [2] [3] [4] 下一页 |
