Hi I'm having trouble trying to figure this out. Any help/example would be grateful.
Thanks Neil On Sun, Dec 21, 2008 at 4:30 PM, Baron Schwartz <ba...@xaprb.com> wrote: > On Fri, Dec 19, 2008 at 1:03 PM, Tompkins Neil > <neil.tompk...@googlemail.com> wrote: > > > of products for all suppliers for a particular product. However I want > to > > be able to show the lowest price product from just the lowest priced > > supplier. > > http://jan.kneschke.de/projects/mysql/groupwise-max > > http://www.xaprb.com/blog/2006/12/07/how-to-select-the-firstleastmax-row-per-group-in-sql/ > > -- > Baron Schwartz, Director of Consulting, Percona Inc. > Our Blog: http://www.mysqlperformanceblog.com/ > Our Services: http://www.percona.com/services.html >