显示查询中的百分比 [英] Showing Percentage in a Query

问题描述

以下是我在查询中使用的代码，该代码产生如下结果：

故障类别 ------------- 无故障总计

无故障------------------------------ 77

总工作单位------------------- 521


我想也要展示在查询中没有错误的百分比。在这种情况下，我需要将52个总工作单位中的77个无故障划分为

。有没有办法做到这一点，并在查询中显示答案。

我不想在报告中看到这个，只是查询。

Below is the code I am using in a query that produces results that look like:

Fault Category-------------No Fault Totals
No Faults------------------------------77
Total Work Units-------------------521

I would like to also show in the query the percentage of No Faults. In this instance I would need to divide
the 77 no faults by the 521 total work units. Is there a way to do this and show the answer in the query.
I do not want this in a report, just the query.

展开 | 选择 | 换行 | 行号

推荐答案

正如Pink Floyd所说有人在那里吗？

As Pink Floyd said Is anybody out there?

下面是我在查询中使用的代码，它产生的结果如下所示：

故障类别 ------------- 无故障总计

无故障------------------------------ 77

总工作单位------------------- 521


我好吗d还想在查询中显示No Faults的百分比。在这种情况下，我需要将52个总工作单位中的77个无故障划分为

。有没有办法做到这一点，并在查询中显示答案。

我不想在报告中看到这个，只是查询。

Below is the code I am using in a query that produces results that look like:

Fault Category-------------No Fault Totals
No Faults------------------------------77
Total Work Units-------------------521

I would like to also show in the query the percentage of No Faults. In this instance I would need to divide
the 77 no faults by the 521 total work units. Is there a way to do this and show the answer in the query.
I do not want this in a report, just the query.

展开 | 选择 | 换行 | 行号

谢谢，

我在哪里插入我的SQL代码？

Thank you,

Where do I insert that in my SQL Code?

这篇关于显示查询中的百分比的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！