[thelist] sql de-doupe

r937 rudy at r937.com
Sat Feb 2 04:48:39 CST 2008


> modelA  cat1
> modelA  cat2
> modelB  cat1
> modelB  cat2
>
> Out of those 4, I need:
>
> modelA  whatever_cat_comes_first
> modelB  whatever_cat_comes_first


unfortunately there is no such thing as "comes first" in a relational 
database

(despite this, msaccess has a FIRST function, but SQL Server doesn't)


how about the lowest category?

   select model, min(cat) from daTable group by model

simple, yes?





More information about the thelist mailing list