从多个表中选择前10条记录(按desc顺序排列)，如下所示: [英] select top 10 records from multiple tables order by desc like below:

问题描述

从多张表中选择前10条记录，按desc顺序排列，如下所示:
1]前9条记录
2]记录的总和作为单个记录

select top 10 records from multiple tables order by desc like below:
1] top 9 records
2] sum of left of records as single records

推荐答案

您并没有付出太多的努力，但是这样的结构可以起作用:

You didn''t give much to work with, but a structure like this could work:

SELECT SUM(...), ...
FROM (SELECT TOP(10)
        CASE WHEN ROW_NUMBER() OVER (...) = 1 THEN ''Set 1''
             ELSE ''Set 2''
        END AS SetID,
        ...
      FROM ...
      ORDER BY ...) A
GROUP BY A.SetID

这篇关于从多个表中选择前10条记录(按desc顺序排列)，如下所示:的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！