如何在求和中减去第二条记录..用了很笨的办法,效率会很差...
如果是除去第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
责任编辑：小草
