话不多说,请看代码:
/*
SELECT ,
[第一个透视的列] AS ,
[第二个透视的列] AS ,
...
[最后一个透视的列] AS ,
FROM
()
AS
PIVOT
(
()
FOR
[]
IN ( [第一个透视的列], [第二个透视的列],
... [最后一个透视的列])
) AS
;
*/
declare tb table
(
cid int
,cname
现有两表A,B A表存储商品点击日志,B表存储商品 要求显示当天所有商品点击量列表并附带总数并按天排序 代码如下: declare sql varchar(2000) set sql=’select CONVERT(varchar(100), a.[Time], 23) as 时间,count(b.title) as 总数’ select sql =sql+ ‘,sum(case b.title when ”’+Title+”’ then 1 else 0 end) as ‘+'[‘+Titl