You can wrap state column in upper / lower function prior to count. Kind regards Arina
On Wed, Feb 8, 2017 at 1:45 PM, Sanjiv Kumar <sanjiv...@gmail.com> 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. >