显示查询中的百分比
问题描述：
以下是我在查询中使用的代码，该代码产生如下结果：
故障类别 ------------- 无故障总计
无故障------------------------------ 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.
展开 | / span> 选择 | 换行 | 行号
答
正如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.
展开 | / span> 选择 | 换行 | 行号
谢谢，
我在哪里插入我的SQL代码？
Thank you,
Where do I insert that in my SQL Code?