Sum() Function

[umeshpotdar]

hello friends
i hav a problem that i face today
problem is

i have a table in Mysql
TableName---- wages

ok

records in that table are like

wId Uid amount
1 1 10000
2 1 10000
3 2 20000
4 2 20000
5 2 20000
6 3 30000
7 3 30000

ok

so i want sum of amount of distinct Uid

i used foll. query
Select * from wages group by Uid

i got result for above

wId Uid amount
1 1 10000
3 2 20000
6 3 30000

now i want sum of amount of these records
means (10000+20000+30000)

so how can use one query do produce this result.

Please help me.

[amitpatel66]

Try This:

 
SELECT wid,uid,SUM(amount) OVER() FROM
(Select * from wages group by Uid)
 
 

[umeshpotdar]

Try This:

 
SELECT wid,uid,SUM(amount) OVER() FROM
(Select * from wages group by Uid)
 
 

Sorry Yar
But it Did'nt worked at my side.
plz
tell me other trick to do same.

[ronverdonk]

This is basic SQL

SELECT uid, SUM(amount) FROM wages GROUP BY uid

Ronald