Re: Group By - Is there a way to set which rows values are used for the fields not in the Group By clause?

lcount, itemname from viewvisitor where ownerid = 2 GROUP BY concat( app, itemid ) ORDER BY totalcount; Rich Carr wrote: >Is there a way to set which rows values are used by the GROUP BY clause for >the fields that are not in the GROUP BY clause? > >In this following select statement the

Re: Group By - Is there a way to set which rows values are used for the fields not in the Group By clause?

Thanks again! Dan Bolser <[EMAIL PROTECTED]> wrote:On Tue, 12 Apr 2005, Rich Carr wrote: >Hi Dan, > Thanks very much! First, I can't figure out how to reply to this so >that it shows up in the MySQL list. How does one do it? erm... if you hit 'reply all' or a

Group By - Is there a way to set which rows values are used for the fields not in the Group By clause?

Is there a way to set which rows values are used by the GROUP BY clause for the fields that are not in the GROUP BY clause? In this following select statement the group by and order work but the value of the lastviewtime field is not the value of the most recent datetime row. Is there any way