SELECT field1,field2,field3,field4,field5,field6,field7,field8,field9,field10 FROM table GROUP BY field2;
I should warn you.... MySQL lets you do this, but other database languages may not. The reason is because you don't say what it is you want to do with the other 9 fields, it would make more sense to write an aggregate function around them. For example:
SELECT max(field1), field2, max(field3),max(field4),max(field5),max(field6),max(field7),max(field8),max(field9),max(field10) FROM table GROUP BY field2;
is not the same as
SELECT min(field1), field2, min(field3),min(field4),min(field5),min(field6),min(field7),min(field8),min(field9),min(field10) FROM table GROUP BY field2;
So fields 1,3,4,5,6,7,8,9,10 may contain "unexpected" or inconsistent data. When I say may- you have to know what you're doing, sometimes those other languages pointlessly require an aggregate function, which brings me to my next point. You can specify multiple columns in the GROUP BY clause:
GROUP BY field1, field2
would be an example. Now there's no question what field1 and field2 will be, you get the distinct permutations of their values. Well, since field1 is the primary key, you will get every record, so maybe group by field2, field3 instead.