CREATE TABLE [dbo].[ExamResult1](
[ID] [uniqueidentifier] NOT NULL,
[PaperID] [uniqueidentifier] NULL,
[UserID] [varchar](50) NULL,
[LengthOfTime] [float] NULL,
[Score] [float] NULL,
[ExamNum] [int] NULL,
[IsMarking] [bit] NULL,
[MarkingTime] [datetime] NULL,
[CreateUser] [nvarchar](100) NULL,
[CreateTime] [datetime] NULL,
[IsDelete] [bit] NULL
)
go
INSERT [dbo].[ExamResult1] ([ID], [PaperID], [UserID], [LengthOfTime], [Score], [ExamNum], [IsMarking], [MarkingTime], [CreateUser], [CreateTime], [IsDelete]) VALUES (N'f34e8dfd-5a6b-4bd9-95d2-0b56de1f43f5', N'464450d5-885d-4090-ba9b-9c825da60f09', N'jiaxj', 1, 120, 1, 0, NULL, N'dengyuxuan', CAST(0x0000A490013EDC20 AS DateTime), 0)
GO
INSERT [dbo].[ExamResult1] ([ID], [PaperID], [UserID], [LengthOfTime], [Score], [ExamNum], [IsMarking], [MarkingTime], [CreateUser], [CreateTime], [IsDelete]) VALUES (N'9fd8df08-cf5b-417e-8a43-24f9bfc15df1', N'464450d5-885d-4090-ba9b-9c825da60f09', N'dengyuxuan', 0, 90, 1, 0, NULL, N'dengyuxuan', CAST(0x0000A4900141A374 AS DateTime), 0)
GO
INSERT [dbo].[ExamResult1] ([ID], [PaperID], [UserID], [LengthOfTime], [Score], [ExamNum], [IsMarking], [MarkingTime], [CreateUser], [CreateTime], [IsDelete]) VALUES (N'7510db73-fbbd-480c-a3e1-4b51c67273eb', N'ef9b6605-1be8-46eb-84b0-6941850db587', N'system', 0, 7, 1, 1, CAST(0x0000A49501349544 AS DateTime), N'system', CAST(0x0000A495013455FC AS DateTime), 0)
GO
INSERT [dbo].[ExamResult1] ([ID], [PaperID], [UserID], [LengthOfTime], [Score], [ExamNum], [IsMarking], [MarkingTime], [CreateUser], [CreateTime], [IsDelete]) VALUES (N'f2e46553-3358-43ab-aff1-6b41f0617153', N'29593ede-8520-44dd-a305-d5984c01f047', N'chenwf', 2, 61, 1, 1, CAST(0x0000A490010892DC AS DateTime), N'chenwf', CAST(0x0000A49000ABA5CC AS DateTime), 0)
GO
INSERT [dbo].[ExamResult1] ([ID], [PaperID], [UserID], [LengthOfTime], [Score], [ExamNum], [IsMarking], [MarkingTime], [CreateUser], [CreateTime], [IsDelete]) VALUES (N'eccf61e3-ae6e-47ad-a27b-81fd844f0956', N'29593ede-8520-44dd-a305-d5984c01f047', N'hanxue', 2, 30, 1, 1, CAST(0x0000A490010868AC AS DateTime), N'hanxue', CAST(0x0000A48F012AA3F4 AS DateTime), 0)
GO
INSERT [dbo].[ExamResult1] ([ID], [PaperID], [UserID], [LengthOfTime], [Score], [ExamNum], [IsMarking], [MarkingTime], [CreateUser], [CreateTime], [IsDelete]) VALUES (N'06fa7adb-f2cf-419b-9b0e-b1e7ade9816c', N'5274376a-4feb-4b98-85b8-c969c87c22ed', N'baigang', 0, 2, 1, 1, CAST(0x0000A490010899E4 AS DateTime), N'baigang', CAST(0x0000A48F00000000 AS DateTime), 0)
GO
INSERT [dbo].[ExamResult1] ([ID], [PaperID], [UserID], [LengthOfTime], [Score], [ExamNum], [IsMarking], [MarkingTime], [CreateUser], [CreateTime], [IsDelete]) VALUES (N'd82356bb-e769-4d6b-a69a-c18264e103df', N'29593ede-8520-44dd-a305-d5984c01f047', N'chenwf', 1, 41, 1, 0, NULL, N'chenwf', CAST(0x0000A490014CE9C8 AS DateTime), 0)
GO
INSERT [dbo].[ExamResult1] ([ID], [PaperID], [UserID], [LengthOfTime], [Score], [ExamNum], [IsMarking], [MarkingTime], [CreateUser], [CreateTime], [IsDelete]) VALUES (N'320083d5-1ebb-449b-b8c4-c271456c3736', N'e8a814de-c666-4887-ac11-55f69962f16f', N'chenwf', 3, 18, 1, 0, NULL, N'chenwf', CAST(0x0000A49000B2F41C AS DateTime), 0)
GO
INSERT [dbo].[ExamResult1] ([ID], [PaperID], [UserID], [LengthOfTime], [Score], [ExamNum], [IsMarking], [MarkingTime], [CreateUser], [CreateTime], [IsDelete]) VALUES (N'd1cede98-a450-4c80-a580-f1b0b25a3b67', N'e8a814de-c666-4887-ac11-55f69962f16f', N'dengyuxuan', 63, 222, 1, 1, CAST(0x0000A490014BAFB8 AS DateTime), N'dengyuxuan', CAST(0x0000A48D00000000 AS DateTime), 0)
这是一张考试结果表，PaperID是试卷ID，UserId是用户ID，Score是这次考试的分数，然后这张表保存所有人的针对不同试卷的考试结果，我现在的需求是查出每个用户针对每张试卷的最高分
结果应该是1张试卷至少有一条及以上的记录，谢谢各位！想了一天还没想出来...
------解决思路----------------------
SELECT PaperID, UserID, Max(Score) Score
FROM ExamResult1
GROUP BY PaperID, UserID
ORDER BY UserID, Score
PaperID UserID Score
------------------------------------ -------------- -------
5274376A-4FEB-4B98-85B8-C969C87C22ED baigang 2.0
E8A814DE-C666-4887-AC11-55F69962F16F chenwf 18.0
29593EDE-8520-44DD-A305-D5984C01F047 chenwf 61.0
464450D5-885D-4090-BA9B-9C825DA60F09 dengyuxuan 90.0
E8A814DE-C666-4887-AC11-55F69962F16F dengyuxuan 222.0
29593EDE-8520-44DD-A305-D5984C01F047 hanxue 30.0
464450D5-885D-4090-BA9B-9C825DA60F09 jiaxj 120.0
EF9B6605-1BE8-46EB-84B0-6941850DB587 system 7.0