Luis Cazares (10/20/2016)

---

That's a weird requirement. What's the story behind this?

Here's a shorter alternative which I expect that might be a bit faster (not much).

WITH numbers AS

(

SELECT ROW_NUMBER() OVER ( ORDER BY id ) AS num

FROM syscolumns

)

SELECT *

FROM numbers

WHERE numbers.num % 10 NOT IN (4, 8) ;