How to achieve this analytic function in Talend

[Anonymous]

SQL> select id , row_number() over(order by id) as row_number, rank() over(order by id) as rank,dense_rank() over (order by id) as dense_rank from a;

ID ROW_NUMBER RANK DENSE_RANK
---------- ---------- ---------- ----------
1 1 1 1
1 2 1 1
2 3 3 2
3 4 4 3
3 5 4 3
4 6 6 4
4 7 6 4
5 8 8 5
6 9 9 6
7 10 10 7

[manodwhb]

@dshunkal99 ,check below links,

Rank

https://community.talend.com/t5/Design-and-Development/how-to-generate-rank/td-p/24991

Dense rank

https://community.talend.com/t5/Design-and-Development/Dense-Rank-function-in-talend/td-p/54281