Find the most recent rows for a repeating sets of data with SQL [email protected] (Simon Hutchinson)

​This post is based upon something I needed to provide to my superiors at my work. We have a history file that contains many thousands of repeating sets records (yes, I know it is time to purge the old data), I was asked to “create a SQL statement” that would return the most recent records for each key. It will make more sense when I show the data I am going to be using here. In these examples the file is named TESTFILE, and contains three columns of data. I can use the following SQL statement to list the contents of this file: 01 SELECT * FROM TESTFILE The results are: Read more » Read More 

Verified by MonsterInsights