sql - 选择所有行并忽略第一行

Question

我当前正在使用以下 SQL 查询，该查询返回 25 行。如何修改它以忽略第一行:

SELECT fiscal_year, SUM(total_sales) as sum_of_year, AVG(SUM(total_sales)) 
OVER () as avg_sum 
FROM sales_report 
GROUP BY fiscal_year 
ORDER BY fiscal_year ASC

我使用的是 SQL Server 2008。

谢谢。

Answer 1

您可以在 SQL Server 2008 中使用EXCEPT。

SELECT fiscal_year, SUM(total_sales) as sum_of_year, AVG(SUM(total_sales)) 
OVER () as avg_sum 
FROM sales_report 
GROUP BY fiscal_year

EXCEPT

SELECT TOP 1 fiscal_year, SUM(total_sales) as sum_of_year, AVG(SUM(total_sales)) 
OVER () as avg_sum 
FROM sales_report 
GROUP BY fiscal_year 
ORDER BY fiscal_year ASC

对于 SQL Server 2012 及更高版本，您可以使用FETCH OFFSET