In last post we have discussed Row_Number() function. In similar way we have RANK function. By the name it is clear that we provide some kind of ranking for rows. It syntax is exact same like ROW_NUMBER(). Now the question comes in mind if it is same then why SQL SERVER introduce new function. …