SELECT
t1.f1,
t1.f2,
t1.f3
FROM
db_table t1
inner join
(
SELECT
f1,f3,f2
FROM
db_table
group by
f1,f3,f2
having count(f1 || f3 || f2) >1
) t2
on t1.f1=t2.f1
and t1.f3=t2.f3
and t1.f2=t2.f2;
t1.f1,
t1.f2,
t1.f3
FROM
db_table t1
inner join
(
SELECT
f1,f3,f2
FROM
db_table
group by
f1,f3,f2
having count(f1 || f3 || f2) >1
) t2
on t1.f1=t2.f1
and t1.f3=t2.f3
and t1.f2=t2.f2;