SELECT rows multiple of x

Question

In SQL Server, how to select rows 10, 20, 30, 40, etc., where RowID is an equal integer break (+10). There are 50k lines, so using IN (1,10,20, etc.) is time consuming.

SELECT * FROM 'TABLENAME' WHERE RowID = 10 (+ 10) 

Answer 1

You can use modulo for this.

 SELECT * FROM `table` WHERE (`id` % 10) = 0 SELECT * FROM `table` WHERE (`id` MOD 10) = 0 SELECT * FROM `table` WHERE !MOD(`id`, 10) 

Anyone should do.

Answer 2

I suspect you need to use the rowId module operator mod 10 = 0. some of this order.