drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Arina Yelchiyeva <arina.yelchiy...@gmail.com>
Subject Re: How to avoid case sensitivity in group by
Date Wed, 08 Feb 2017 11:48:51 GMT
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 <sanjivktr@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.
>

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