Jenender Chawla

Sql Query: I need to compare data for 2 dates while using GROUP BY <InvDate> results in multiple rows like Row1 - InvDate1 | Sum(Data Col1) | Row2 - InvDate2 | Sum(Data Col1) | But I need like Row1 - Sum(Data Col1) for InvDate1 | Sum(Data Col1) for InvDate2 Kindly help resolving it! Thanks! Jenender