Actually
moritz's solution gives you the data you want:
[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 fr
+uit 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)
This is using Sybase ASE 15.
Michael