Using the MySQL SUM() function

[pankajit09]

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 ?

[gauravgmbhr]

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'

[gauravgmbhr]

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

[pankajit09]

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 ?

[pankajit09]

BUT I GUESS UR CODE WILL ALSO WORK
WATS EXACTLY U R LOOKIN FOR

I want to avoid using SUM in all the fields.

[gauravgmbhr]

I want to avoid using SUM in all the fields.

u want to get the sum of all entries in ur table but u dun wanna use aggregate functions?????

is that what u want

[pankajit09]

U WANT TO GET THE SUM OF ALL ENTRIES IN UR TABLE BUT U DUN WANNA USE AGGREGATE FUNCTIONS?????

IS THAT WHAT U WANT

NO

I wanna use Aggregate functions with a different way if possible ?

[gauravgmbhr]

NO

I wanna use Aggregate functions with a different way if possible ?

i know what u don't want but
i am not able to get what u want
plz explain briefly

well i explained a method above in my previous post

[gauravgmbhr]

i know what u don't want but
i am not able to get what u want
plz explain briefly

well i explained a method above in my previous post

are u talking bout something related to complete table scan that u don't want

[pankajit09]

are u talking bout something related to complete table scan that u don't want

NO

I just don't want to use SUM with every field of the table.

Now you got ?

[mohsenhosseini]

NO

I just don't want to use SUM with every field of the table.

Now you got ?

hi dear,
if you dont want realy user SUM() for your field to return back the some value,
i think you have to use PROCEDURE s or FUNCTION in your Database.

then just use CALL function to use the functions.

search and read more about user defiened functions and store procedure in your DBMS.

it will looks like this.

mysql> delimiter //

mysql> CREATE PROCEDURE mysum (IN field INT,OUT res INT)
-> BEGIN
-> SELECT SUM( field ) INTO res FROM t;
-> END;
-> //
Query OK, 0 rows affected (0.00 sec)

mysql> delimiter ;

[gauravgmbhr]

NO

I just don't want to use SUM with every field of the table.

Now you got ?

U want to Do the SUM but Dont Wanna Use Sum()????

TEll me what u wanna Do , Not wat U dont wanna Do.
i understood wat u dont Wanna Do, But didnt Get Wat u wanna Do

[gauravgmbhr]

U want to Do the SUM but Dont Wanna Use Sum()????

TEll me what u wanna Do , Not wat U dont wanna Do.
i understood wat u dont Wanna Do, But didnt Get Wat u wanna Do

YA the Guy Before Me is right

Try This
Stored Procedures