sql custom select

Question

Could anybody please help me with query

Lets say my table table has rows like 1,2,3,4,5,......50k I would like to select rows likely 1,3,5,....49997,49999 or 1,4,7...49997 Pls help me how to achieve this in sql and as well as in linq Thank you

Please show a sample of your data. – Gordon Linoff Nov 15 '15 at 20:49 — Gordon Linoff, Nov 15 '15 at 20:49

score 0 · Accepted Answer · edited May 23 '17 at 12:15

0

SQL Server/MySQL/Postgresql/SQLite version using modulo division:

SELECT *
FROM your_table
WHERE id % 2 = 1;

SELECT *
FROM your_table
WHERE id % 3 = 1;

As jarlh mentioned in comment there is MOD(id, x) operator in standard SQL (not working in SQL Server/SQLite)

edited May 23 '17 at 12:15

Community

1
1

answered Nov 15 '15 at 20:29

Lukasz Szozda

162,964
23
234
275

1

And ANSI/ISO SQL answer has MOD(id, 2) etc. – jarlh Nov 15 '15 at 20:32

sql custom select

1 Answers1