Sanjiv, Can you share the query and the output you get through sql server?
Thanks, Dechang ________________________________ From: Sanjiv Kumar <[email protected]> Sent: Wednesday, February 8, 2017 5:01:27 AM To: [email protected] Subject: Re: How to avoid case sensitivity in group by lower and upper is not a solution which i am aspecting. I want to display same output as i get through sql server management studio On Wed, Feb 8, 2017 at 5:15 PM, Sanjiv Kumar <[email protected]> wrote: > Drill Environment:- OS:- Window 10 > Version:- 1.9 > Mode:- embedded mode > > I have a column name 'State' in db, which have data like(e.g:- Florida, > florida,new jersey, etc). > > My problem is while using count(State) and group by in query, > Florida and florida are showing two seperate rows. > > So how to avoid case sensitivity so that both Florida and florida act as > 1 rows while firing count(Sate).? > > > -- > Thanks & Regards. > Sanjiv Kumar. > -- Thanks & Regards. Sanjiv Kumar.
