query to get following output

this is my table

BatchName    SubBatch   records     
12032014     raw1_0     2  
12032014     raw1_0     2  
12032014     raw1_1     2  
12032014     raw1_1     2     
12302014     raw7_0    150  
12302014     raw7_0    150  

want to get output like BatchName SubBatch records

12032014 raw1_0 4

12032014 raw1_1 4 12302014 raw7_0 300