Get a Specific group of Column with RANK FUNCTION ?
Anonymous
Learn how to use PARTITION in Window function to Solve this.(I know this Question is incomplete but try to Solve already solved queries with CTEs and Window Function ).
Check out your Company Bowl for anonymous work chats.