oracle查询某一列，去除重复值

　SELECT father from zz group by father

不知道为什么之前要想这么复杂。。。。。。。。。。。。。。

 

 

 

 

 

 

 

SELECT * FROM (select Father ,
　　Row_number() OVER (PARTITION BY Father ORDER BY Father) rn
　　from zz
　　) where RN = 1