drew.allen (1/11/2012)
I think it's actually even simpler.
SQL Kiwi (1/11/2012)
That has a different semantic though. Example:
That's true, but this statement from the original poster sounds like the GROUP BY is the correct version.
kevin_nikolai (1/10/2012)
If NOT 1st year and same Programme for same Student, then return no results.
He say 1st year, not 1st consecutive year. Of course, that could simply be a result of poor wording on the part of the OP.
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA