🚀 go-pugleaf

Mark & Lee schrieb:

> Can someone please help me as I am new to SQL and having a bit of trouble
> with an assignment. Problem is:
>
> I need to create a single textfile with a statement that addresses the
> following:
>
> This query is about tracks that have the same length on the same album. For
> each pair of such tracks, display one row showing the length, the album
> code, and the title of each matching track,
>
> e.g. 191     7599-27313-2      Dont Stop     I dont want to know
>
> cannot show the same pair of tracks more than once, i.e with the track
> titles swapped around.
>
>       191    7599-27313-2     Dont Stop          I dont want to know
>       191   7599-27313-2      I dont want to know           Dont Stop.
>
> What I have done so far is,
>
>     Select Length,AlbumCode,TrackTitle from Tracks
> Group by Length,AlbumCode,Tracktitle
> having count (Length) >1;
>
> but of course query is looking for Length,AlbumCode and Tracktitle which has
> a count greater than 1...Result NIL
>
> How can I get around this?????
>
> Mark

I 'm not sure if I really understand your question. Perhaps this is a solution

Select T1.Length,T1.AlbumCode,T1.TrackTitle,T2.TrackTitle
from Tracks T1,Tracks T2
where
 T1.Length=T2.Length and
 T1.AlbumCode=T2.AlbumCode and
 T1TrackName<T2.TrackName

guenter nowak