Sql_server的查询如何转换为oracle的?
SELECT
'IP' [Type],
[1],[2],[3],[4],[5],[6],[7],[8],[9],[10],[11],[12],
([1]+[2]+[3]+[4]+[5]+[6]+[7]+[8]+[9]+[10]+[11]+[12]) [Total]
FROM(
SELECT SUM([1]) [1], SUM([2]) [2],SUM([3]) [3],SUM([4]) [4],SUM([5]) [5],SUM([6]) [6],SUM([7]) [7],SUM([8]) [8],SUM([9]) [9],SUM([10]) [10],SUM([11]) [11],SUM([12]) [12]
FROM(
SELECT [Year],ISNULL([1],0) [1],ISNULL([2],0) [2],ISNULL([3],0) [3],ISNULL([4],0) [4],ISNULL([5],0) [5],ISNULL([6],0) [6],ISNULL([7],0) [7],ISNULL([8],0) [8],ISNULL([9],0) [9],ISNULL([10],0) [10],ISNULL([11],0) [11],ISNULL([12],0) [12]
FROM [HitCount]
PIVOT(SUM(IPCount) FOR [Month] IN ([1],[2],[3],[4],[5],[6],[7],[8],[9],[10],[11],[12])) t
WHERE [Year]=@year
) t
GROUP BY [Year]
) t
本人对oracle一窍不通,基于sql_server开发了一个程序,客户变卦却要oracle的,坑死我了,请大家帮我看看,谢谢!!!