in oracle sql how can i find all values in one column for which in another column exist more than one distinct value?

You need having with group byaggregate functions don’t work with where clause

SELECT code 
       FROM mytable
group by code
having COUNT(DISTINCT info) >1

CLICK HERE to find out more related problems solutions.

Leave a Comment

Your email address will not be published.

Scroll to Top