Re: Problem with GROUP BY

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

> 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

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

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

Problem with GROUP BY

I created a table with, CREATE TABLE info ( number INTEGER UNSIGNED, event INTEGER UNSIGNED, name VARCHAR(2000) NOT NULL, PRIMARY KEY (number, event) ); and populated it with data to produce this, ++---+---+ | number | event | name | ++---+---+ |

Re: query problem with GROUP BY and ORDER BY

On Sat, 01 Jun 2002 11:58:38 +0200 Claire Forchheimer <[EMAIL PROTECTED]> wrote: I know the answer to the first part at least. I think you want to use two columns in the order by clause, and leave out the group by clause. As in: select * from tbl order by apt, name; I'm afraid its too late a

query problem with GROUP BY and ORDER BY

Hi all, I have a table including two colums: names and apartment numbers: apt #| name -- 1 | Smith Joe 1 | Smith Anne 2 | Doe Richard 3 | Svensen Mike 3 | Brant Liza I need to get a list in alphabetical order, but with people in the same apt keept together: Brant, S

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

> "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

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

> > 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

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

Problem with GROUP BY ... DESC

Hello: I'm new to the list and have a question. I upgraded from version 3.22 to this version: 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