Posted by Mark on 09/21/07 07:41
On Sep 18, 5:27 am, David Portas
<REMOVE_BEFORE_REPLYING_dpor...@acm.org> wrote:
> On 18 Sep, 08:30, Ed Murphy <emurph...@socal.rr.com> wrote:
>
>
>
> > This could return multiple values if there's a tie for most
> > common type.
>
> Correct. So could the version using TOP WITH TIES. Mark said: "I want
> to know the type that has the max units in any group". If there is
> more than one such type then the specification is incomplete because
> Mark doesn't say which one should come "first". Rather than pick a
> random row or make the assumption that there is only one row I decided
> it was safer to return everything - that way Mark can decide for
> himself whether he needs to refine his spec.
>
> --
> David Portas
Thanks guys. You'd think they'd have a "standard" (and simple) method
for doing this eh?
[Back to original message]
|