需要包含查询来计算结果(need to envelop query to count results)

需要包含查询来计算结果(need to envelop query to count results)

我有这个问题：

SELECT [QUERY1].[py], [QUERY1].[al], [QUERY1].[ga], [QUERY1].[sy], [QUERY1].[pl] FROM [tab-Sample] as QUERY1, [tab-Sample] WHERE [tab-Sample].[py] = [QUERY1].[py] AND [tab-Sample].[al] <> [QUERY1].[al]

我想写一个查询，jsut计算这一个的结果，我找不到在哪里插入Count（*）也试过Over（）但我无法管理这个。

i have this query:

SELECT [QUERY1].[py], [QUERY1].[al], [QUERY1].[ga], [QUERY1].[sy], [QUERY1].[pl] FROM [tab-Sample] as QUERY1, [tab-Sample] WHERE [tab-Sample].[py] = [QUERY1].[py] AND [tab-Sample].[al] <> [QUERY1].[al]

I would like to write a query that jsut counts the results of this one, i cannot find where to insert the Count(*) also tried with Over() but im unable to manage this.

最满意答案

将所有内容包装为FROM的子选择。 确保你的名字（ Total ）。

COUNT (*) AS Amount FROM ( SELECT [QUERY1].[py], [QUERY1].[al], [QUERY1].[ga], [QUERY1].[sy], [QUERY1].[pl] FROM [tab-Sample] as QUERY1, [tab-Sample] WHERE [tab-Sample].[py] = [QUERY1].[py] AND [tab-Sample].[al] <> [QUERY1].[al] ) Total

Wrap everything as a sub selection in the FROM. Make sure you name it however (Total).

COUNT (*) AS Amount FROM ( SELECT [QUERY1].[py], [QUERY1].[al], [QUERY1].[ga], [QUERY1].[sy], [QUERY1].[pl] FROM [tab-Sample] as QUERY1, [tab-Sample] WHERE [tab-Sample].[py] = [QUERY1].[py] AND [tab-Sample].[al] <> [QUERY1].[al] ) Total