Hi guys. I have a table named CertificationEvents wich has a VersionNumber field (i.e. the rows are versioned). For example, I can have these records:
ID VersionNumber
1 1
1 2
1 3
2 1
3 1
3 2
I need to retrieve only the last version of each row, i.e. for the previous sample, I want to get:
ID VersionNumber
1 3
2 1
3 1
I found this: http://stackoverflow.com/questions/1971801/nested-select-in-llblgen, but does not work because I need to refer to the same table
Any ideas?
