表student結構如下:求每個學生分數最高的科目及分數。
SQL：
select s.* from (select *,row_number() over (partition by name order by score desc) as rownumber from [COMMON].[dbo].[student]) s where s.rownumber=1;
查詢結果：
Copyright @ Jakin.zhou Powered by: .Text and ASP.NET Theme by: .NET Monster
