數(shù)據(jù)庫輔導(dǎo)：SQLSUM除去第二條記錄

如何在求和中減去第二條記錄..用了很笨的辦法,效率會(huì)很差...
    如果是除去第N條記錄,我該怎么辦??
    = =還有會(huì)出現(xiàn)沒有第N條記錄的時(shí)候...
    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]
    --結(jié)果
    drop table #table