I have a question. Does dense_rank() function work in teradata? I have tried it at quite a few places and it never seems to work.
It is there in 14.10. You can have a look at the example given there, else you have to develop a logic for it. In TD 15 , there are lots of new functions. I think it is time to upgrade to avail new features :).