my application is like below. To get 2 records after a special records. But wrong count, the count is 5: sqlite> sqlite> CREATE TABLE t1 (id INTEGER PRIMARY KEY, data INTEGER); sqlite> INSERT INTO t1 VALUES (3, 999); sqlite> INSERT INTO t1 VALUES (2, 989); sqlite> INSERT INTO t1 VALUES (4, 1009); sqlite> INSERT INTO t1 VALUES (7, 1019); sqlite> INSERT INTO t1 VALUES (9, 1029); sqlite> INSERT INTO t1 VALUES (10, 1039); sqlite> SELECT * FROM t1 WHERE id>=3 LIMIT 2; # right 3|999 4|1009 sqlite> SELECT COUNT(*) FROM t1 WHERE id>=3 LIMIT 2; # wrong count, why? 5 sqlite>
____________________________________________ I'm confused that the "count(*)" return wrong count. -- View this message in context: http://old.nabble.com/to-get-2-records-after-a-special-records.-But-wrong-count%2C-the-count-is-5-tp27981805p27981805.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
