本文介绍了如何在同一个查询中添加两个选择命令的结果的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着跟版网的小编来一起学习吧!
问题描述
我目前有两个选择命令,如下所示.我想要做的是将结果添加到 SQL 查询中,而不是代码中的变量.
I currently have two select commands as per below. What I would like to do is to add the results together in the SQL query rather than the variables in code.
select sum(hours) from resource;
select sum(hours) from projects-time;
是否可以在同一个 SQL 中同时输出两个结果的总和?
Is it possible to have both in the same SQL and output a sum of both results?
推荐答案
是的.可能 :D
SELECT SUM(totalHours) totalHours
FROM
(
select sum(hours) totalHours from resource
UNION ALL
select sum(hours) totalHours from projects-time
) s
作为旁注,必须对表名 projects-time
进行分隔以避免语法错误.分隔符因您使用的 RDBMS 而异.
As a sidenote, the tablename projects-time
must be delimited to avoid syntax error. Delimiter symbols vary on RDBMS you are using.
这篇关于如何在同一个查询中添加两个选择命令的结果的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!
本站部分内容来源互联网,如果有图片或者内容侵犯了您的权益,请联系我们,我们会在确认后第一时间进行删除!