sql query help
Posted on 2009-05-03
i have a table which contains product names and qty.they are repeated many times inthe table.i want to collect all the product and sum their qty.
now i want three rows like this
where XXX is the sum of all its qty