# Define DB views with DISTINCT

> A 'Distinct' checkbox has been added on the View Component tab.

**Goal:** Technical

**Developer:** Nicolas Micoud

**Sponsor:** [TGI](http://tgi.eu)

**Feature Ticket:** [IDEMPIERE-5434](https://idempiere.atlassian.net/browse/IDEMPIERE-5434)

**Description:**

![DBViewDistinct](pathname:///img/new-features/v10/DBViewDistinct.png)

If ticked, *DISTINCT* is automatically added right after the *SELECT* keyword in the query