【总结】去重的SQL

1. Group-by，最简单的办法
select owner from all_objects group by owner;

2. 分析函数
select owner from (
select owner, row_number() over (partition by owner order by owner) rn
from all_objects
) 
where rn=1;