SQL Command To Select Distinct

select distinct list_name from CODELIST_XREF_ITEM

This SQL command will allow you to select distinctly the whole table for code lists.