Select distinct rows from two fields

Arts_Girl

New Member
I have a table that has millions of records. So I might have these columnsa, b, c, dI need to select all the distinct records based on columns a and b.But I need to select columns a, b, c and d not just a and b.Can I do this?editData might be\[quote\] 1,1,frog,green 1,1,frog,brown 2,1,cat,black 2,4,dog,white\[/quote\]so i need;\[quote\] 1,1,frog,green 2,1,cat,black 2,4,dog,white\[/quote\]
 
Top