Page 1 of 1

mysql Query

Posted: Wed Mar 18, 2009 3:29 am
by ullasvk
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.

Re: mysql Query

Posted: Wed Mar 18, 2009 4:12 am
by deejay
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

Posted: Wed Mar 18, 2009 4:15 am
by susrisha

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
 
 
Finally figured it out..

Re: mysql Query

Posted: Wed Mar 18, 2009 4:52 am
by drewan
hi

Re: mysql Query

Posted: Wed Mar 18, 2009 8:11 am
by susrisha
got an update on the query man

Code: Select all

 
Select D,S,sum(W)
 
From goods
 
Group by D,S
 

Re: mysql Query

Posted: Wed Mar 18, 2009 9:52 am
by pickle
A straight database query question is better suited for the "Databases" forum. Moving.