hi all, i m getting a problem with a query, i want to select records having unique values in field2 while field1 is primary key...

so when i run the
Code:
SELECT DISTINCT(field2) FROM table
it goes fine but i get only one field in result.

when i try this
Code:
SELECT DISTINCT(field2),field1,field3,field4,field5,field6,field7,field8,field9,field10 FROM table
i get all fields but not unique values in field2