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
Get empowered with IBM Power
