Re: [sqlite] Why this LIMIT

2018-03-11 Thread Cecil Westerhof
2018-03-11 9:49 GMT+01:00 Clemens Ladisch : > Cecil Westerhof wrote: > > I see that in certain older queries I use: > > LIMIT (SELECT COUNT(*) FROM TABLE) > > > > ​It looks like​ this has no use (limiting the selected records to the > > number of records there are). Anyone an idea what could

Re: [sqlite] Why this LIMIT

2018-03-11 Thread Clemens Ladisch
Cecil Westerhof wrote: > I see that in certain older queries I use: > LIMIT (SELECT COUNT(*) FROM TABLE) > > ​It looks like​ this has no use (limiting the selected records to the > number of records there are). Anyone an idea what could be a reason for > this? Trying to put some table data in

[sqlite] Why this LIMIT

2018-03-10 Thread Cecil Westerhof
I see that in certain older queries I use: LIMIT (SELECT COUNT(*) FROM TABLE) ​It looks like​ this has no use (limiting the selected records to the number of records there are). Anyone an idea what could be a reason for this? -- Cecil Westerhof __