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

For example: we have some products with diff colors. I 开发者_如何学JAVAwant to get its colors. If I add to view fields the color field I will get duplicates (colors) in output.

Needs realize something like GROUP BY field_color_value in sql-query.

I don't understand at all what do you want to do. For example, what are the colors? (terms, item from a text listbox field...).

Without having this information I can tell you that in some view's style settings (click on the gear icon next to style), you can group by the fields you have in the view's field section.