MS-SQL Case when

felixsyan

于 2011-05-26 15:37:00 发布

阅读量139

点赞数

CC 4.0 BY-SA版权

分类专栏： SQL 文章标签： SQL Go

本文链接：https://blog.csdn.net/felixsyan/article/details/83936486

SQL 专栏收录该内容

18 篇文章

订阅专栏

本文介绍如何使用 SQL 中的 CASE WHEN 语句进行数据的分组与排序，通过具体示例展示了根据不同价格区间对商品进行分类的方法，并且演示了如何在 SELECT 和 ORDER BY 子句中使用 CASE WHEN 来实现数据的灵活展示。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

显示时间：

select   getdate()   as   日期,case   month(getdate())   
  when   11   then   '十一'   
  when   12   then   '十二'   
  else   substring('一二三四五六七八九十',   month(getdate()),1)   
  end+'月'   as   月份

GROUP BY 子句中的 CASE when

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 的Case when

SELECT 
    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 AS Range, 
     Title 
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, 
     Title 
ORDER 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, 
     Title 
GO