SEO

#1 (**permalink**) 02-28-2008, 08:34 AM

Say I have a table like this:

customer_number | name

I'd like to do a group by the customer_number unless the
customer_number is negative, at which point, I'd like to group by name.

Unfortunately, I'm not really sure how to do that. Any ideas?

#2 (**permalink**) 02-28-2008, 08:34 AM

>Say I have a table like this:
>
>customer_number | name
>
>I'd like to do a group by the customer_number unless the
>customer_number is negative, at which point, I'd like to group by name.
>
>Unfortunately, I'm not really sure how to do that. Any ideas?

Write an expression that returns the customer_number unless the
customer_number is negative, in which case, it returns the name.
Hint: if()

Now group by that.

#3 (**permalink**) 02-28-2008, 08:35 AM

yawnmoth wrote:
> Say I have a table like this:
>
> customer_number | name
>
> I'd like to do a group by the customer_number unless the
> customer_number is negative, at which point, I'd like to group by
> name.
>
> Unfortunately, I'm not really sure how to do that. Any ideas?

Either like Gordon said or UNION 2 queries, one of which deals with the
negative customer numbers and the other which deals with the rest

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

conditional group by?