New posts in Dense Rank

How to emulate SQLs rank functions in R?