drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sanjiv Kumar <ktrsan...@gmail.com>
Subject Re: How to avoid case sensitivity in group by
Date Thu, 09 Feb 2017 09:58:01 GMT
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.

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message