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 theit goes fine but i get only one field in result.Code:
SELECT DISTINCT(field2) FROM table
when i try this
i get all fields but not unique values in field2 :( :(:confused:Code:
SELECT DISTINCT(field2),field1,field3,field4,field5,field6,field7,field8,field9,field10 FROM table