Distinct Values in Value Set

To get distinct values in a valueset (without creating a view), the following steps can be followed

In the place of table name use the following
(select distinct column_name from table_name) a

where 'a' is the alias nameIn the value field give
a.column_name