I need to return values in a column where only the unique values are returned. I know that DISTINCT will return only unique values, however i need to completely ommit any that are duplicated.
Column 1 Column 2
You want to use
group by and
select column1, column2 from table t group by column1, column2 having count(*) = 1;
EDIT: (based on comment by knkarthick24)
Depending on what the OP intends, this might also be correct:
select column1, max(column2) from table t group by column1 having count(*) = 1;