如何查找计数 [英] How to find the count

问题描述

我有一个列状态，其状态为

'已回答'

'未回答'

'Busy'



i需要这样的支付



count（已回答+无人接听+忙碌） /（计数（已回答+未答复））

。可以提供任何帮助。

Hi,
I have a column Status having data like
'Answered'
'Non Answered'
'Busy'

i need out put like this

count(Answered+Nonanswered+Busy) / (count(Answered+NonAnswered))
.Can any one help on this.

推荐答案

尝试

Try

Select (count(answered) + count(nonanswered) + count(busy))/ (count(answered)+ count(nonanswered)) as ans from table group by status

这篇关于如何查找计数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！