Re: [Q] SQL statement grouping by a field , and ordering within a group

From: Joachim Pense <joachim.pense_at_t-online.de>
Date: Fri, 15 Dec 2000 22:16:00 +0100
Message-ID: <91e1mf$ppi$05$2@news.t-online.com>

Perhaps you should consider ORDER BY ARTIST, SONG? joachim

steveee_ca_at_my-deja.com wrote:

> Hi ,
>
> How about
>
> SELECT ARTIST,SONG
> FROM TABLE
> ORDER BY ARTIST;
>
> Regards,
>
> Steve
>
>
>
> In article <3A39CA1C.77D741A_at_igs.inter-gate.co.jp>,
> Kyoichi Ozaki <k-ozaki_at_igs.inter-gate.co.jp> wrote:
> > hi all,
> >
> > i have an question considering a SQL statement.
> >
> > here is what i have, and want to do.
> >
> > i have a table with artist,songs,song ids.
> >
> > 0001 personA song1
> > 0002 personA song2
> > 0003 personB song3
> > 0004 personC song4
> > 0005 personA song6
> > 0006 personA song5
> > 0007 personD song7
> >
> > and i want to creat a SQL statement that generates a result
> > that is grouped by artist, and ordered by songs owned by that
> > artist.
> >
> > 0001 personA song1
> > 0002 personA song2
> > 0006 personA song5
> > 0005 personA song6
> > 0003 personB song3
> > 0004 personC song4
> > 0007 personD song7
> >
> > please help
> >
> > ---
> > Kyoichi Ozaki
> > k-ozaki_at_igs.inter-gate.co.jp
> >
> >
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Fri Dec 15 2000 - 15:16:00 CST