問題描述：

透視功能是excel最常用的操作之一，對于取數(shù)需求來說非常常見，如何利用mysql予以實(shí)現(xiàn)呢？

解決思路：

• 用臨時(shí)表+表鏈接的形式即可實(shí)現(xiàn)，例如

create temporary table aa as 
(select CustomerID as '客戶ID',sum(Quantity) as '2017購買數(shù)量' from orderinfo 
	where year(OrderDate)='2017'
	and orderinfo.CustomerID in (select distinct CustomerID from orderinfo where year(OrderDate)='2016')
	group by CustomerID);

create temporary table bb as 
(select CustomerID as '客戶ID',sum(Quantity) as '2016購買數(shù)量' from orderinfo 
	where year(OrderDate)='2016'
	group by CustomerID) ;
	
select aa.客戶ID,2016購買數(shù)量,2017購買數(shù)量 from aa,bb where aa.客戶ID=bb.客戶ID;