Hasn't anyone here (or who read the Oracle magazine) heard of correlated sub-queries?

select aField from aTable t1

where 2 = (select count(*) from aTable t2

where t2.aField > t1.aField)