SELECT
PL_SITE.SITE_NUMBER,
sum(DailyReport.ClinkerYeildDay) AS production
FROM
dbo.[ DailyReport ]
LEFT JOIN PL_SITE ON DailyReport.factoryKey = PL_SITE.OBJECT_KEY
WHERE
1 = 1
GROUP BY
PL_SITE.SITE_NUMBER order by sum(DailyReport.ClinkerYeildDay) desc  limit 5

上面是MySQL语法~

--------------------------

下面是SQL server 语法~

SELECT top 5
PL_SITE.SITE_NUMBER,
sum(DailyReport.ClinkerYeildDay) AS production
FROM
dbo.[ DailyReport ]
LEFT JOIN PL_SITE ON DailyReport.factoryKey = PL_SITE.OBJECT_KEY
WHERE
1 = 1
GROUP BY
PL_SITE.SITE_NUMBER order by sum(DailyReport.ClinkerYeildDay) desc

select top 5 * from (

SELECT

PL_SITE.SITE_NUMBER,

SUM (

DailyReport.ClinkerYeildDay

) AS production

FROM

dbo.[ DailyReport ]

LEFT JOIN PL_SITE ON DailyReport.factoryKey = PL_SITE.OBJECT_KEY

WHERE

1 = 1

GROUP BY

PL_SITE.SITE_NUMBER

  order by production desc) t

SQLSERVER中可以使用

ROW_NUMBER () OVER (ORDER BY SUM (R.销售额) DESC) 排序

来进行排序，然后包一层，select 表明.查询字段,表明.排序  就可以了  where后面加个表明.排序<=5