获取行数
获取行数
提问于 2012-10-12 14:14:03
我有以下sql查询。我想要得到所有的行数。有人能帮我吗？
WITH numberedrows
AS (SELECT DISTINCT TOP 10 f_feeid_pk,
f_code,
f_description,
f_fee,
f_areaid_ind_fk,
a_name_ind,
p_name_ind,
s_name_ind,
b_name_ind,
Row_number()
OVER (
ORDER BY b_name_ind, s_name_ind, p_name_ind,
a_name_ind, f_code ASC) AS
RowNumber
FROM t_fee
INNER JOIN t_area
ON f_areaid_ind_fk = a_areaid_pk
INNER JOIN t_project
ON a_projectid_fk = p_projectid_pk
INNER JOIN t_section
ON p_sectionid_fk = s_sectionid_pk
INNER JOIN t_branch
ON s_branchid_fk = b_branchid_pk
WHERE f_feeid_pk > 0)
SELECT *
FROM numberedrows 回答 1
Stack Overflow用户
回答已采纳
发布于 2012-10-12 14:18:39
将该DISTINCT TOP 10替换为DISTINCT以获得所有不同的结果，假设您只对distinct的计数感兴趣，否则也删除distinct，然后将SELECT更改为使用COUNT(*)
WITH numberedrows
AS (SELECT DISTINCT f_feeid_pk,
f_code,
f_description,
f_fee,
f_areaid_ind_fk,
a_name_ind,
p_name_ind,
s_name_ind,
b_name_ind,
Row_number()
OVER (
ORDER BY b_name_ind, s_name_ind, p_name_ind,
a_name_ind, f_code ASC) AS
RowNumber
FROM t_fee
INNER JOIN t_area
ON f_areaid_ind_fk = a_areaid_pk
INNER JOIN t_project
ON a_projectid_fk = p_projectid_pk
INNER JOIN t_section
ON p_sectionid_fk = s_sectionid_pk
INNER JOIN t_branch
ON s_branchid_fk = b_branchid_pk
WHERE f_feeid_pk > 0)
SELECT COUNT(*) FROM numberedrows;页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/12853276
复制相关文章
相似问题
腾讯云开发者
