drill-user mailing list archives

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



-- 
Thanks & Regards.
Sanjiv Kumar.

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