使用MySQL SUM（）函数 [英] Using the MySQL SUM() function

问题描述

我的SQL查询是 - >


SELECT sum（预订），sum（发票）FROM alaqary WHERE alasas =" WQ"


我找到了两个字段的总和。


还有更好的办法吗？

解决方案

我的SQL查询是 - >


SELECT sum（预订），sum（发票）FROM alaqary WHERE alasas =" WQ"


我找到了两个字段的总和。


还有更好的办法吗？

试试这个


SELECT s1.Sum，s2.Sum

FROM（SELECT sum （预订）Sum，alasas

来自alagary）s1，

（SELECT sum（发票）Sum，alasas

来自alagary）s2，

WHERE s1.alasas =''WQ''

AND s2.alasas =''WQ''

试试这个


SELECT s1.Sum，s2.Sum

FROM（SELECT sum（预订）Sum，alasas

来自alagary）s1，

（选择总和（发票）总和，alasas

来自alagary）s2，

WHERE s1.alasas =''WQ''

AND s2.alasas =''WQ''

但我想你的代码也会工作

wats完全正在寻找

试试这个


SELECT s1.Sum，s2.Sum

FROM（选择总和（预订）总和，alasas

来自alagary）s1，

（SELECT sum（发票）Sum，alasas

FROM alagary）s2，

WHERE s1.alasas =''WQ''

AND s2.alasas =''WQ''

为什么要这么复杂？

My SQL query is -->

SELECT sum(bookings),sum(invoices) FROM alaqary WHERE alasas="WQ"

I am finding the sum of two fields .

Is there any better way ?

解决方案

My SQL query is -->

SELECT sum(bookings),sum(invoices) FROM alaqary WHERE alasas="WQ"

I am finding the sum of two fields .

Is there any better way ?

try this

SELECT s1.Sum, s2.Sum
FROM (SELECT sum(bookings) Sum , alasas
FROM alagary) s1,
(SELECT sum(invoices) Sum , alasas
FROM alagary) s2,
WHERE s1.alasas=''WQ''
AND s2.alasas=''WQ''

try this

SELECT s1.Sum, s2.Sum
FROM (SELECT sum(bookings) Sum , alasas
FROM alagary) s1,
(SELECT sum(invoices) Sum , alasas
FROM alagary) s2,
WHERE s1.alasas=''WQ''
AND s2.alasas=''WQ''

but i guess ur code will also work
wats exactly u r lookin for

try this

SELECT s1.Sum, s2.Sum
FROM (SELECT sum(bookings) Sum , alasas
FROM alagary) s1,
(SELECT sum(invoices) Sum , alasas
FROM alagary) s2,
WHERE s1.alasas=''WQ''
AND s2.alasas=''WQ''

Why to make it so complex ?

这篇关于使用MySQL SUM（）函数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！