Is it possible to identify last row in result set of a query within that query? I am working on a WBS graphical representation (like in Visio) and because of some formatting, I have to be able to know which row is the last one.
Let's say that I want to create a simple list that should show all of my tasks , together with the mark if it is the last task or not, something like this:
- Task 1 | No
- Task 2 | No
- Task 3 | No
- Task 4 | No
- Task 5 | No
- Task 6 | Yes
Thanks