Posted by: niss March 19, 2016
Oracle simple help
Login in to Rate this Post:     1       ?         Liked by
If your table has a PK all rows should be distinct by definition. If you are trying to just select DISTINCT field but somehow return all other columns what should happen for those columns that have more than one value for a particular field value? so You would need to use GROUP BY and some sort of aggregation on the other columns.

select * from table group by column name.
Read Full Discussion Thread for this article