Sql Query: I need to compare data for 2 dates in a row

[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