我有这样的桌子
|FailCount| TC Name| Hierarchy | RC | Category|
我正在尝试总结FailCount,并为每个唯一的层次结构显示TC名称的总数。我有一个搜索查询可以做到这一点:
select sum(FailCount) as 'Failure Count', count(*) as 'TC Count', `Hierarchy` from FailReport_Table
where Category in ('Category1,Category2') and OWNER = 'Raja'
group by `Hierarchy` order by `Failure Count` desc";
所以这会给我类似的东西
|Failure Count | TC Count| Hierarchy|
|12 | 143| abc.fc.nf|
|1 | 134| ghjs.sk|
与此表格一起,我想要其他字段作为RC。每个唯一的层次结构可以具有不同的RC,我想显示该层次结构的任何一个RC。
我试图在这样的上一个查询中包括RC,但是没有用。
select sum(FailCount) as 'Failure Count', count(*) as 'TC Count', `Hierarchy`, RC from FailReport_Table
where Category in ('Category1,Category2') and OWNER = 'Raja'
group by `Hierarchy` order by `Failure Count` desc";
我是SQL新手。
如果您需要显示给定层次结构的任何RC,则可以使用MAX()函数来获取max_rc_field,如下所示
select sum(FailCount) as 'Failure Count'
, count(*) as 'TC Count'
, `Hierarchy`
, MAX(RC) as RC
from FailReport_Table
where Category in ('Category1,Category2')
and OWNER = 'Raja'
group by `Hierarchy`
order by `Failure Count` desc";
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句