Reply to Re: Retrieve ONLY first/max

Your name:

Reply:


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]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация