sql equivalent of first.variable not equal to last.variable

[SASPhile]

in datastep if we want to select all those not distinct records first.variable ne last.variable logic can be applied.
Is there an equivalent in proc sql?

[SASPhile]

Got it:

group by variable name
having count(*)>1