Hi, If anyone could point me in the right direction, I'd be most grateful.
Thanks ! Neil On Mon, Dec 22, 2008 at 9:55 AM, Tompkins Neil <neil.tompk...@googlemail.com > wrote: > 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 >> > >
