Skip to content
Advertisement

Select carried over reports

How do I get the carried over reports + the very first report from the following table?

Result should be : 304, 306, 309, and 312.

After a little bit of tinkering, the solution needed some tweaking when there is only one caseID.

Advertisement

Answer

You can use EXISTS :

User contributions licensed under: CC BY-SA
2 People found this is helpful
Advertisement