Re: Problem with GROUP BY

2008-10-20 Thread Moon's Father
Learnt! On Wed, Oct 15, 2008 at 5:28 PM, philip <[EMAIL PROTECTED]> wrote: > > Date: Tue, 14 Oct 2008 16:55:11 +0300 > > From: Olexandr Melnyk <[EMAIL PROTECTED]> > > To: [EMAIL PROTECTED], mysql@lists.mysql.com > > Subject: Re: Problem with GROUP BY > >

Re: Problem with GROUP BY

2008-10-15 Thread philip
> Date: Tue, 14 Oct 2008 16:55:11 +0300 > From: Olexandr Melnyk <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED], mysql@lists.mysql.com > Subject: Re: Problem with GROUP BY > > http://jan.kneschke.de/projects/mysql/groupwise-max > > 2008/10/14 Peter Brawley <

Re: Problem with GROUP BY

2008-10-14 Thread Olexandr Melnyk
http://jan.kneschke.de/projects/mysql/groupwise-max 2008/10/14 Peter Brawley <[EMAIL PROTECTED]> > Philip > > mysql> SELECT number, MAX(event), name FROM info GROUP BY number; >> > > For discussion & examples see "Within-group aggregates" at > http://www.artfulsoftware.com/queries.php. > > PB >

Re: Problem with GROUP BY

2008-10-14 Thread Peter Brawley
Philip mysql> SELECT number, MAX(event), name FROM info GROUP BY number; For discussion & examples see "Within-group aggregates" at http://www.artfulsoftware.com/queries.php. PB - philip wrote: I created a table with, CREATE TABLE info ( number INTEGER UNSIGNED, event INTEGE

Re: Re: Problem with GROUP BY ... DESC

2001-12-10 Thread Michael Widenius
> "Arjen" == Arjen G Lentz <[EMAIL PROTECTED]> writes: Arjen> Hi, Arjen> - Original Message - Arjen> From: "AJ" <[EMAIL PROTECTED]> >> > > Ver 11.15 Distrib 3.23.46, for pc-linux-gnu (i686) >> > > The problem that has cropped up I have is that in all GROUP BY column >> > > DESC >>

Re: Re: Problem with GROUP BY ... DESC

2001-12-04 Thread Arjen G. Lentz
Hi, - Original Message - From: "AJ" <[EMAIL PROTECTED]> > > > Ver 11.15 Distrib 3.23.46, for pc-linux-gnu (i686) > > > The problem that has cropped up I have is that in all GROUP BY column DESC > > > statements, the DESC is now not being recognized, and the query is being > > > returned

Fwd: Re: Problem with GROUP BY ... DESC

2001-12-04 Thread AJ
> > Ver 11.15 Distrib 3.23.46, for pc-linux-gnu (i686) > > > > The problem that has cropped up I have is that in all GROUP BY column DESC > > statements, the DESC is now not being recognized, and the query is being > > returned in ascending order. If I use ORDER BY... DESC that works fine. > >I'

Re: Problem with GROUP BY ... DESC

2001-12-04 Thread Dave Rolsky
On Tue, 4 Dec 2001, AJ wrote: > Ver 11.15 Distrib 3.23.46, for pc-linux-gnu (i686) > > The problem that has cropped up I have is that in all GROUP BY column DESC > statements, the DESC is now not being recognized, and the query is being > returned in ascending order. If I use ORDER BY... DESC th