按2列获取分组,日期最晚

你只是想 MAX(date) :

Select   BMC.JCRS_Mem_crs_Code,
         BMC.JCRS_Mem_Description,
         MAX(BMC.JCRS_Mem_Date) as JCRS_Mem_Date,
         BJCM.JCRS_Mast_Title
From     Bus_MemberCourse BMC
Inner Join Bus_JourneymanCourseMaster BJCM
    On BMC.JCRS_Mem_crs_Code = BJCM.JCRS_Mast_Code
Where BMC.JCRS_Mem_Completed = 1
And   BMC.JCRS_Mem_mem_ID = 5010
Group By BMC.JCRS_Mem_crs_Code,
         BMC.JCRS_Mem_Description,
         BJCM.JCRS_Mast_Title

Group by (您在查询中没有进行任何聚合)。

Row_Number() 带窗口的函数 Partition 按日期订购时,在这两列上:

;With Cte As
(
    Select   BMC.JCRS_Mem_crs_Code,
             BMC.JCRS_Mem_Description,
             BMC.JCRS_Mem_Date,
             BJCM.JCRS_Mast_Title,
             Row_Number() Over (Partition By BMC.JCRS_Mem_crs_Code,
                                             BMC.JCRS_Mem_Description
                                Order By     BMC.JCRS_Mem_Date Desc) As RN
    From     Bus_MemberCourse BMC
    Inner Join Bus_JourneymanCourseMaster BJCM
        On BMC.JCRS_Mem_crs_Code = BJCM.JCRS_Mast_Code
    Where    BMC.JCRS_Mem_Completed = 1
             And BMC.JCRS_Mem_mem_ID = 5010
)
Select  JCRS_Mem_crs_Code,
        JCRS_Mem_Description,
        JCRS_Mem_Date,
        JCRS_Mast_Title
From    Cte
Where   RN = 1