SQLServerCentral » Latest topics
Help with ranking records within years
Hi,
I need to create a report that shows that last time a person completed a course each year. I've figured out dense_rank() to the point where it will rank by date all the times a user completed a given course, but I can't rank within the year.
I need to create a report that shows that last time a person completed a course each year. I've figured out dense_rank() to the point where it will rank by date all the times a user completed a given course, but I can't rank within the year.
No comments:
Post a Comment