How to create value set with distinct values

The problem  is  while creating a "Table Value Set" the value set  showing duplicate data.

Here is the solution for the problem.
 While creating the value set we can write a sql query in the table name.

Example: We are creating a Receipt number value set from table rcv_shipment_headers

Step 1. create the value set with all mandatory fields.

Now click on edit information:

Then write the sql query : (select distinct receipt_num from  rcv_shipment_headers)a in table name field.
Table columns Value : a.receipt_num

 

Click Test and done.