Rank()使用

找出column1对应多个column_2的查询：

---------------------------------------------

select * from (select rank() over(partition by order by    desc) rk, table_name.* 

from table_name) T 

where T.rk>=2;