I need some help with an sql statement that i've been trying to run.

I have a db table on Oracle 8i with the following fields

sqno, f1, f2, f3, f4, f5, f6

Only the sqno field have unique values in them. The rest of them may have duplicate values

Firstly i need to find unique combinations of values in fields f1, f2 and f3. This is easy using the SELECT DISTINCT f1, f2, f3 command
...