分组依据之外的按列排序

你必须做出决定 哪一个 fileid 你关心的。然后可以使用聚合函数:

SELECT FileGuid, FileName, ROW_NUMBER() OVER (Order by MIN(FileId)) AS rownum
FROM dbo.FileImport
GROUP BY FileGuid, FileName
ORDER BY rownum;

您可以使用此SQL语句。

Select *
From 
(
  SELECT T.FileGuid, T.FileName, ROW_NUMBER() OVER(Order by T.FileId) AS rownum 
  from (
     SELECT FileGuid, FileName, Max(FileID) As FileID
     FROM dbo.FileImport
     GROUP BY FileGuid, FileName
  )T
)Temp
order by Temp.rownum

如果有问题,请告诉我!

您可以尝试以下操作:

SELECT * FROM 
(SELECT FileGuid, FileName, ROW_NUMBER() OVER(Partition by FileGuid, FileName
Order by FileId) AS rownum
FROM dbo.FileImport) X
WHERE rownum = <<your condition>>
ORDER BY X.FileGuid,X.FileName,X.rownum

通过添加外部where子句,可以对rownum应用任何类型的过滤器。