select
*
from
table1 t
where
(
select
count
(* )
from
table1
where
a=t.a
and
b=t.b
and
c=t.c)>1
select
*
from
table1 t
where
(
select
count
(* )
from
table1
where
a=t.a
and
b=t.b
and
c=t.c)>1