SQL相关问题的解决_20150730

(2)sql server语句 用count对group by 以后的表按name字段进行统计的问题？ [问题点数：49分]

http://bbs.csdn.net/topics/391112905?page=1#post-399530498

SQL code?DECLARE @t TABLE(id INT,n int ,v int)INSERT INTO @t (id,n,v) VALUES (1,1,234),(1,2,235),(1,3,436),(2,1,235),(2,2,4356) SELECT id,n,v,SUM(v) OVER(PARTITION BY id) AS [你要的列]  FROM @T GROUP BY id,n,v/*id          n           v           你要的列----------- ----------- ----------- -----------1           1           234         9051           2           235         9051           3           436         9052           1           235         45912           2           4356        4591*/

(1)变量声明、if else的使用等

declare @num int

declare @num1 int
SELECT @num=DATEDIFF(year,'1865-7-24','2065-7-24')

print @num

if @num > 10
begin
set @num1 = 11
end
else
begin
set @num1 = 6
end

print @num1