[AccessD] Why Cannot I select Top N in this query

Paul Hartland paul.hartland at googlemail.com
Fri Aug 3 02:05:00 CDT 2018


I didn't think there would be much (if any) difference in those, this is a
case of that it is just down to user preference really and in most cases
there are also a few other ways that query could be written.

Paul

On 3 August 2018 at 04:12, Ryan Wehler <wrwehler at gmail.com> wrote:

> Looks good to me. SQL servers query optimizer is pretty smart I guess.
>
> > On Aug 2, 2018, at 9:51 PM, Bill Benson <bensonforums at gmail.com> wrote:
> >
> > Actual Query Plan
> > <https://drive.google.com/open?id=1g2ulL410xFrsOufzvjAiccMad5UYfEnF> is
> > same.
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



-- 
Paul Hartland
paul.hartland at googlemail.com


More information about the AccessD mailing list