Hello This is my input table in db:- State Price Alaska 75 Texas 80 Alaska 90 Florida 100 florida 70
Sql Server Query:- select State, Sum (Price) from testTable group by State. Sql Server Output:- State Price Alaska 165 Texas 80 Florida 170 Drill Query:- select T1.State, Sum(T1.Price) from <pluginName>.<testTable> T1 group by T1.State. Drill Output:- State Price Alaska 165 Texas 80 Florida 100 florida 70 I want same output as shown in Sql Server Output. Please help.
