Problem We want to compare two moving averages in SQL. We’ll use window functions to do this, as

Problem You want to remove duplicates in SQL. You know it is easy to find duplicates using GROUP

Problem You need to find duplicates and then identify the records by their primary keys. Background Here’s an

Problem How do you create a moving average using windows functions in SQL? Background There is no built-in