Re: BUG: query with 'group by' fails to find matching row[s] (fwd)

[Richard G. Harman Jr]

Yes, infact kalle volkov <cal6@stripped> told me what 'group by' does.

Thank you for all your help, everybody.

Richard


On Sat, 10 Apr 1999, Shaun Batterton wrote:

> Richard, I think the query you are interested in is:
> select artist,filename from mp3 where full_path like '%mary%' ORDER BY
> artist;
> 
> 
> not your original query:
> >select artist,filename from mp3 where full_path like '%mary%' group by 
> >artist;
>