How to get distinct values in table value set

Method1:

While creating table value set write your SQL statement directly in the place of table name but don’t miss to use distinct and alias name for SQL statement as shown below

Method2:

Build Query with rowid to avoid the duplicate values 

Syntax:

SELECT COLUMN_NAME

  FROM TABLE_NAME T1

 WHERE ROWID = (SELECT MAX (ROWID)

                  FROM TABLE_NAME T2

                 WHERE T1.ID = R2.ID)

Method3:

Create view to get distinct values and use the same view while you are creating table value set.

Example:

Create view EMP_V as select distinct deptno from emp;

Method4:

While creating value set ,check the check box “Allow Parent Values” as shown below screenshot.