检索每个客户的最新记录

;WITH x AS (    SELECt ID, NAME, [DATE],       rn = ROW_NUMBER() OVER       (PARTITION BY NAME ORDER BY [DATE] DESC)    FROM @TESTABLE)SELECt ID, NAME, [DATE] FROM x WHERe rn = 1  ORDER BY [DATE] DESC;

尽量避免使用保留字（和模糊的列名），例如

[DATE]