Q: How can I remove repeat records according to one field with other attributes retained?

A: You can use SQL query to realize the purpose. You need to compose the sql statement “*, distinct Field_name”in the SQL Query dialog box.