我有一个简单的MSAccess查询,我只是想不出如何在SQL server中进行复制。我知道Server没有最初的作为函数,但是它有FIRST_VALUE,但我无法使它工作。以下是我尝试过的:Count(CROSS_REFERENCE) as CountOFCROSS_REFERENCE,
FIRST_VALUE(CROSS_REFERENCE
我编写了以下查询 data.id, PARTITION BY data.idORDER BY CAST(FROM_UNIXTIME(ts) AS TIMESTAMP) LAST_VALUE(CAST(FROM_UNIXTIMEOVER ( ORDER BY CAST(FROM_UNIXTIME(ts) AS TIMES