如何找到前三个工资的总和，其中表格上的总行有六行

Question

如何找到前三个工资的总和，其中表格上的总行有六行。

id      Salary
01       100
02       200
03       300
04       400
05       500
06       600

Answer 1

尝试使用这个.....

SELECT SUM(salary) 
FROM
    (SELECT
        ROW_NUMBER() OVER (ORDER BY id ASC) AS ROW_NUMBER, salary
     FROM tablename) AS foo
WHERE 
    ROW_NUMBER <= 3

Answer 2

你的意思是：

SELECT SUM(Salary)
FROM (
    SELECT Salary FROM your_table ORDER BY id LIMIT 3
) A

Answer 3

假设它是SQL Server：

 SELECT SUM(Salary) As SalaryTotal
 (    
     SELECT TOP 3 * FROM your_table ORDER BY ID
 )

如果您想要最高 3 份薪水的总和，那么您可以按薪水订购：

SELECT SUM(Salary) As SalaryTotal
(    
    SELECT TOP 3 * FROM your_table ORDER BY  salary DESC    
)