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

From: <steveee_ca_at_my-deja.com>
Date: Fri, 15 Dec 2000 13:34:29 GMT
Message-ID: <91d6l5$qj3$1@nnrp1.deja.com>

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 - 07:34:29 CST