I'm a newbie on sql query, please throw some light on following :
Table like:
col1 col2 col3 col4
1 10.00 abc company
2 20.00 def company
2 30.00 def company
3 40.00 ghi company
Result should be like:
col1 col2 col3 col4
1 10.00 abc company
2 50.00 def company
3 40.00 ghi company
thanks.
Table like:
col1 col2 col3 col4
1 10.00 abc company
2 20.00 def company
2 30.00 def company
3 40.00 ghi company
Result should be like:
col1 col2 col3 col4
1 10.00 abc company
2 50.00 def company
3 40.00 ghi company
thanks.