From: alexandre.lemiere on
Uri and Plamen, thanks to you two.
It helps me.
From: Uri Dimant on
That's what I missed, Plamen:-)



"Plamen Ratchev" <Plamen(a)SQLStudio.com> wrote in message
news:n9CdnSqU3aR7OSHWnZ2dnUVZ_sWqnZ2d(a)speakeasy.net...
> Hi Uri,
>
> The request was to avoid using the TOP option and to write the query in
> ANSI SQL. This is why I did the rewrite with subquery.
>
> --
> Plamen Ratchev
> http://www.SQLStudio.com