SQL SUM 除去第二条记录..

今天在群里有朋友问到.... 

如何在求和中减去第二条记录..闲来无事 写了一下,觉得思路很死..用了很笨的办法,效率会很差...

如果是除去第N条记录,我该怎么办??

= =还有会出现没有第N条记录的时候...

if object_id('tempdb.dbo.#table') is not null drop table #table
if object_id('tempdb.dbo.#table') is not null drop table #table1
create table #table ([id] int IDENTITY(1,1) ,[name] varchar(5),values1 int)

insert into #table ([name],values1) values ('A',1)
insert into #table ([name],values1) values ('A',2)
insert into #table ([name],values1) values ('A',3)
insert into #table ([name],values1) values ('B',1)
insert into #table ([name],values1) values ('B',2)
insert into #table ([name],values1) values ('B',3)
insert into #table ([name],values1) values ('B',4)
insert into #table ([name],values1) values ('B',5)
go
select * from #table --原始table

select * from #table where id not in
  (select min([id]) from #table where id not in
     (select min([id]) from #table group by [name]) group by [name])
--处理后的table

select [name],sum(values1) from #table where id not in
  (select min([id]) from #table where id not in
     (select min([id]) from #table group by [name]) group by [name])
group by [name]
--结果
drop table #table

 

--希望能抛砖引砖.....