'Select columns which have more the 2 values in other column

I have a table which have 3 columns and we need to select data of those rows which have multiple entry in the table.

 Column1  Colum2    Colum3
 ---------------------------
 ARRG   | MEM      | 10.12
 ARRG   | MHH      | 0.245
 ARRG   | MHH      | 0.246
 ABC    | HQ       | 0.246
 CDE    | PRT      | 97.0
 TST    | TRY      | 97.0

Now I want to write a query to select rows from Column1 which have unique values in Colum2 Basically i want to print the rows of ARRG as this have 2 different values in Colum2.

ARRG   | MEM      | 10.12
ARRG   | MHH      | 0.245
mysql


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions