I don't see how that would work?
I could do a join on the total sales price once I have the top 5, but I was
hoping there was something as easy as WITH TIES.
Kind regards,
Taco Fleur
Free Call 1800 032 982 or Mobile 0421 851 786
Pacific Fox http://www.pacificfox.com.au an industry l
Taco Fleur wrote:
> Sorry, should have included it>
>
> WITH TIES
>
> Specifies that additional rows be returned from the base result set
with the
> same value in the ORDER BY columns appearing as the last of the TOP n
> (PERCENT) rows. TOP ...WITH TIES can only be
Sorry, should have included it>
WITH TIES
Specifies that additional rows be returned from the base result set with the
same value in the ORDER BY columns appearing as the last of the TOP n
(PERCENT) rows. TOP ...WITH TIES can only be specified if an ORDER BY clause
is specified.
Kind rega
Taco Fleur wrote:
Hi all,
is there a WITH TIES function to use with the LIMIT keyword?
What does that WITH TIES function should do?
Greets
Barry
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o)
--
MySQL General Mailing List
For list archives: http
Hi all,
is there a WITH TIES function to use with the LIMIT keyword?
Kind regards,
Taco Fleur
Free Call 1800 032 982 or Mobile 0421 851 786
Pacific Fox <http://www.pacificfox.com.au/> http://www.pacificfox.com.au an
industry leader with commercial IT experience sinc