Hi all, I create a table like this: sqlite3_exec(db, "CREATE TABLE TBLNAME (ID INTEGER PRIMARY KEY , NAME TEXT)", 0, 0,&zErrMsg); Then insert some records, the follow is the contents of this table. ------------------------------------- ID NAME ================== (1) 1 AA (2) 2 BB (3) 3 CC (4) 4 DD (5) 5 EE (6) 6 FF (7) 7 GG --------------------------------------
Then may delete some records, ------------------------------------- ID NAME ================== (1) 1 AA (2) 3 CC (3) 4 DD (4) 6 FF (5) 7 GG -------------------------------------- I want to find the Nth record, for example,when N=3 , I want to get this record : "4 DD" , N=5 : "7 GG" . The N value is given, and how can do it fast? Thanks Yoky _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users