The query is as follows:
select * from my_table where (rowid,0) in (select rowid, mod(rownum,n) from my_table )
sqlite3
-
I just tried sqlite. It is ultra-light and support SQL commands. Just try
this $ sqlite3 test.db SQLite version 3.26.0 2018-12-01 12:34:55 Enter
".help" fo...
3 weeks ago
No comments:
Post a Comment