From: Stefan Hoffmann on
hi Plamen,

On 03.03.2010 16:21, Plamen Ratchev wrote:
> SELECT staff_id
> FROM test
> GROUP BY staff_id
> HAVING MAX(year) - MIN(year) <> COUNT(DISTINCT year) - 1;
Ah, easier to understand than the Gauss approach.


mfG
--> stefan <--