sql server - Is it possible to sum records from a column based on records from a different column? -
jobno stepno workcntr hours 10342-63 10 cutting 1.95 10390-30 10 cutting 2.59 10390-32 10 cutting 3.45 10390-34 10 cutting 2.55 10390-34 10 cutting 1.82
so have table above, here's code:
select distinct orderdet.jobno, orderdet.stepno, orderdet.workcntr, orderdet.hours orderdet;
what i'd sum hours if job number same , have distinct filter out duplicate, ideally, table should this:
jobno stepno workcntr hours 10342-63 10 cutting 1.95 10390-30 10 cutting 2.59 10390-32 10 cutting 3.45 10390-34 10 cutting 4.37
any way this? using sql server 2012. in advance
this basic aggregation query using sum()
, group by
:
select jobno, stepno, workcntr, sum(hours) hours orderdet group jobno, stepno, workcntr
Comments
Post a Comment