我有这个查询:
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]
我想写一个只计算这个结果的查询,我找不到在哪里插入 Count(*) 也尝试过使用 Over() 但我无法管理这个。
将所有
内容包装为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