Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
samlopez06
Starting Member
4 Posts |
 Posted - 2014-11-08 : 01:50:25
|
| Hi everyone. I have a table Item_used like thisItemname Employee Quantitypencil samlopez 10pencil samlopez 5All I want is to make a report that sum all the quantity of the same items with the same employee like thisItemname Employee Quantitypencil samlopez 15 |
|
|
singularity
Posting Yak Master
153 Posts |
Posted - 2014-11-08 : 15:48:45
|
| [code]select Itemname, Employee, sum(Quantity) as Quantityfrom Item_used agroup by Itemname, Employee[/code] |
 |
|
|
|
|
|
sum quantity with like employee and itemname