Hello Friends .
I am doing a project in php based on inventory management. I have a table in my database called goods i.e.,
Table : goods
D S W
9 68 75
9 68 75
9 72 100
9 72 100
9 75 150
9 75 150
10 78 200
10 78 200
10 78 200
Now i want a query that returns the values as follows
D S W
9 68 150 //[75+75 =150]
9 72 200 //[100+100=200]
9 75 300 //[150+150=300]
10 78 600 //[200+200+200=600]
How to write the mysql query for this.
Can any one please help me.
If not plz give me some idea how to do this.
mysql Query
Moderator: General Moderators
Re: mysql Query
it'll probably be best if you have a go at writing it and then if that doesn't work let us have a look at what you've got and we can give you some pointers to help.
Re: mysql Query
Code: Select all
SELECT COUNT( W ) * W, D, S
FROM goods
GROUP BY D, W
HAVING COUNT( D ) >1
AND COUNT( S ) >1
LIMIT 0 , 30
//output
COUNT( W )*W D S
150 9 68
200 9 72
300 9 75
600 10 78
Re: mysql Query
got an update on the query man
Code: Select all
Select D,S,sum(W)
From goods
Group by D,S
Re: mysql Query
A straight database query question is better suited for the "Databases" forum. Moving.
Real programmers don't comment their code. If it was hard to write, it should be hard to understand.