[thelist] sql de-doupe

[Brian Cummiskey]

r937 wrote:

> so go ahead and use GROUP BY, like this --
> 
>    SELECT model
>         , MIN(cat) 
>         , COUNT(foo)
>         , AVG(bar)
>         , ...  
>      FROM daTable 
>    GROUP 
>        BY model
> 
> but i already know what you're going to say next
> 
> ;o)
> 

I wish I was on mysql instead?  haha