数据在SQL中的逐年比较 [英] Side-by-side comparison of data by year in SQL

问题描述

我的表格类似于以下内容：

I have table similar to the following:

Year | Product |  Value
2006   A          10
2006   B          20
2006   C          30
2007   A          40
2007   B          50
2007   C          60

我想要一个返回以下比较的查询

I would like a query that would return the following comparison

Product | 2006 Value | 2007 Value
A         10           40
B         20           50
C         30           60

有什么选择吗？可以在没有连接的情况下完成吗？

What are the options to do so? Can it be done without joins?

我正在使用DB2，但所有SQL类型的答案都将有所帮助。

I'm working with DB2, but answers in all SQL types would be helpful.

推荐答案

select Product, 
    max(case when Year = 2006 then Value end) as [2006 Value], 
    max(case when Year = 2007 then Value end) as [2007 Value] 
from MyTable
group by Product
order by Product

这篇关于数据在SQL中的逐年比较的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！