[59] 192.168.174.128 5010.my_db2.(sa).1> select * from fruit;
 t                    c
 -------------------- --------------------
 orange               yellow
 orange               red
 banana               yellow
 mellon               yellow
 mellon               red
 raisin               green

(6 rows affected)

[61] 192.168.174.128 5010.my_db2.(sa).1> select t, c, count(*) from fruit group by t having count(*) > 1 order by t;
 t                    c
 -------------------- -------------------- -----------
 mellon               red                            2
 mellon               yellow                         2
 orange               red                            2
 orange               yellow                         2

(4 rows affected)