T-SQL,如何得到这些结果?

试试这个

SELECT  PA.refPatient_id,
        PA.datee,
        PR.temporary,
        PA.statue
FROM    PatientClinicActs AS PA INNER JOIN
        (
            SELECT  PA.refPatient_id,
                    MAX(PA.datee) AS datee
            FROM    PatientClinicActs AS PA
            WHERE   PA.refClinic_id = 25          
            GROUP BY PA.refPatient_id,PA.statue,PA.datee,
        ) AS MaxDates ON PA.refPatient_id = MaxDates.refPatient_id AND PA.datee = MaxDates.datee INNER JOIN
        PatientStatueReasons AS PR ON PA.refreason_id = PR.reason_id

您需要先获取每个患者的最大日期,然后再加入。

而不是交叉联接

FROM PatientClinicActs AS PA
                ,PatientStatueReasons AS PR

你能试试内连接吗

FROM PatientClinicActs AS PA

INNER JOIN PatientStatueReasons AS PR 

ON PA.refreason_id = PR.reason_id

WHERE PA.refClinic_id = 25 

对于这种情况,有另一种方法可以获得 最新的 使用记录 SQL Server Ranking functions .

我已经用过 DENSE_RANK() 我的答案,但你可以用 RANK() 而不是针对你的特定问题。
( 笔记 :未测试以下代码。如果要为表提供模式,我将使用示例数据进行测试)

;with RankedResult as (
    SELECT  
    PA.refPatient_id
    , PA.datee
    , PR.temporary,
    , PA.statue
    --; Last datee has the lowest rank value of 1,
    , dense_rank() over 
        (partition by PA.refPatient_id order by PA.datee desc) as [Rank]
    FROM    PatientClinicActs AS PA
            join PatientStatueReasons AS PR on PA.refreason_id = PR.reason_id
    WHERE   PA.refClinic_id = 25 
)
select  distinct *
from    RankedResult
--; Get only the last result.
where   [Rank] = 1

将pa.date从group by子句中取出