Question Steven Henry Su... · Dec 17, 2024 How To Give a Condition To Data Row based on First and Next Data? Hello my Friends, I have a question, I have a data like this And I want to create a display like this, which I can put a status column beside the Item Column The status become new, if there's no previous item, and if there's a same item after the first one, the status become Old Does anyone could help me ? #Key Question #SQL #VSCode #InterSystems IRIS #Other #TrakCare 0 9 0 140