Second to Last Revision

,

I need to be able to always select the second to last revision in a BAQ. What is the best method of doing this? We use both numbers and letters for Revision Nums.

I would check out Windowing Functions. People usually select the top, latest, etc. but you can select number 2 as well.

2 Likes