[ORACLE] 找出是第幾順位 DNESE_RANK()/RANK()

有dense不會跳號排序 (有兩筆以上的資料順位相同 也會以同樣的順位排列)

select dense_rank() over(order by birthday ),birthday,name
from member
where to_char(birthday, 'YYYY/MM/DD') ='2014/01/01'
orderby的用法就和平常一樣

也可以設定是要partition by什麼
例如：
select rank() over(partition by 性別 order by birthday ),birthday,name
from member
where to_char(birthday, 'YYYY/MM/DD') ='2014/01/01'