Off the top of my head, I can think of a couple of ways.
select lower(name), count(*) from customer group by lower(name);
or
select min(name), count(*) from customer group by lower(name);
The second one works if you still want some semblance of the original
casing of the field.
On Jun 28, 2004, at 9:15 AM, UMPA Development wrote:
> Hello all!
>
> Is it possible to setup a group by to be case insensitive and if so
> how?
>
> Thank you!
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 8: explain analyze is your friend
>