CREATE TABLE [dbo].[Score](
[ID] [int] IDENTITY(1,1) PRIMARY KEY NOT NULL,
[Name] [nvarchar](50) NULL,
[CID] [int] NULL,
[Score] [int] NULL
）
INSERT INTO [Test].[dbo].[Score]([Name],[CID],[Score])VALUES('張三',1,60)
INSERT INTO [Test].[dbo].[Score]([Name],[CID],[Score])VALUES('張三',2,70)
INSERT INTO [Test].[dbo].[Score]([Name],[CID],[Score])VALUES('張三',3,80)
INSERT INTO [Test].[dbo].[Score]([Name],[CID],[Score])VALUES('張三',4,90)
INSERT INTO [Test].[dbo].[Score]([Name],[CID],[Score])VALUES('李四',1,60)
INSERT INTO [Test].[dbo].[Score]([Name],[CID],[Score])VALUES('李四',2,70)
INSERT INTO [Test].[dbo].[Score]([Name],[CID],[Score])VALUES('李四',3,80)
INSERT INTO [Test].[dbo].[Score]([Name],[CID],[Score])VALUES('李四',4,90)
INSERT INTO [Test].[dbo].[Score]([Name],[CID],[Score])VALUES('王五',1,60)
INSERT INTO [Test].[dbo].[Score]([Name],[CID],[Score])VALUES('王五',2,70)
INSERT INTO [Test].[dbo].[Score]([Name],[CID],[Score])VALUES('王五',3,80)
INSERT INTO [Test].[dbo].[Score]([Name],[CID],[Score])VALUES('王五',4,90)
好了，準(zhǔn)備工作做完了，下面我們來寫兩條Sql語句，解決開始提出的那兩個問題
A、統(tǒng)計學(xué)生的成績
select name,SUM(Score)Score from Score group by Name
B、刪除表中重復(fù)的記錄，因為這表中的name是有重復(fù)的，所以我們就直接用這表來test
delete from Score where Name in
(select Name from Score group by Name having COUNT(name)>0)and ID
not in (select MIN(id) from Score group by Name having COUNT(Name)>0)
好了，兩條語句解決了兩個問題.