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