Hi,
I am a newbie to sql,I have a problem with querying the intended result.What i need is to get the SUM() of daily income,cost im my result set, but it gives me unintended result set hence it gets duplicated by GROUP BY clause.please correct my sql.
Thank you.
this is what i want
+------------+--------+------+
| date | Income | Cost |
+------------+--------+------+
| 2010-05-12...
2 results in 0.0013 seconds.
-
Multiple Sum() values with GROUP BY Problem
-
Count numbers group wise according to identical time in PHP and MYSQL
Dear Xperts,
In my database table some fault code type records are inserted and the values are like bellows:
Error:2/FC:10; 00:15:13 16/03/2009;
Error:2/FC:20; 00:15:15 16/03/2009;
Error:2/FC:30; 00:15:16 16/03/2009;
Error:2/FC:40; 00:15:20 16/03/2009;
Error:3/FC:3; 00:20:13 16/03/2009;
Error:3/FC:6; 00:20:15 16/03/2009;
Error:3/FC:9; 00:20:16 16/03/2009;
...
