Sql Query: I need to compare data for 2 dates in a row in General Posted September 2, 2020 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
Sql Query: I need to compare data for 2 dates in a row
in General
Posted
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