Given a table with duplicate data, how would I extract only specific rows based on business requirements provided.
Sigiloso
Use of a common table expression and a window function to rank data was answer provided, as simple use of distinct or filtering wouldn't give needed results.