How to remove duplicates (nodes with the same fields) from drupal 7 view? -

for example: have products diff colors. want colors. if add view fields color field duplicates (colors) in output.

needs realize group field_color_value in sql-query.

i don't understand @ want do. example, colors? (terms, item text listbox field...).

without having information can tell in view's style settings (click on gear icon next style), can group fields have in view's field section.