On Wed, 17 May 2006, Malk0 wrote:
[...]
BUT if i add a GROUP BY clause in the subselect the results returned
in ct is just false ex:
- doing
SELECT count(*) FROM (SELECT * FROM mytable GROUP BY col1) _TMPTABLE_;
return one row with 20 in ct and that's FALSE, this is the total
amount of row in my
First of all i'm using Sqlite for 2 years now and just want to tell
it's great! that's done and now here's why i'm sending this message to
the list:
I'm working on pagination and want to retrieve the number of row that
i would normally retrieve without the Limit clause. So i hoped to use
subselect
2 matches
Mail list logo
