sqliteUtil::initDB("test.db"); //pk integer primary key autoincrement,
string sql5 ="CREATE TABLE roundsdata(id INTEGER PRIMARY KEY AUTOINCREMENT,type INTEGER, round INTEGER ,rightnum INTEGER,time not null default (datetime('now','localtime')))";
sqliteUtil::createTable(sql5, "roundsdata");
sqliteUtil::insertData("insert into roundsdata(type, round ,rightnum) values(1,1,2)");
sqliteUtil::insertData("insert into roundsdata(type, round ,rightnum) values(1,2,2)");
sqliteUtil::insertData("insert into roundsdata(type, round ,rightnum) values(1,3,2)");
sqliteUtil::insertData("insert into roundsdata(type, round ,rightnum) values(1,4,12)");
sqliteUtil::insertData("insert into roundsdata(type, round ,rightnum) values(2,1,2)");
sqliteUtil::insertData("insert into roundsdata(type, round ,rightnum) values(2,2,2)");
sqliteUtil::insertData("insert into roundsdata(type, round ,rightnum) values(2,3,2)");
sqliteUtil::insertData("insert into roundsdata(type, round ,rightnum) values(2,4,2)");
sqliteUtil::insertData("insert into roundsdata(type, round ,rightnum) values(2,5,2)");
sqliteUtil::insertData("insert into roundsdata(type, round ,rightnum) values(3,1,2)");
sqliteUtil::insertData("insert into roundsdata(type, round ,rightnum) values(3,4,12)");
sqliteUtil::insertData("insert into roundsdata(type, round ,rightnum) values(3,5,2)");
sqliteUtil::insertData("insert into roundsdata(type, round ,rightnum) values(4,1,2)");
sqliteUtil::insertData("insert into roundsdata(type, round ,rightnum) values(4,2,2)");
sqliteUtil::insertData("insert into roundsdata(type, round ,rightnum) values(4,2,12)");
sqliteUtil::insertData("insert into roundsdata(type, round ,rightnum) values(4,3,22)");
tableMes* tablemes = sqliteUtil::getdatas("select A.* from roundsdata A inner join (select max(round) as round,type as type from roundsdata where rightnum<10 group by type) B on A.round=B.round and A.type=B.type limit 3");
char** re = tablemes->getRes();
int r = tablemes->getRow();
int c = tablemes->getCol();
for(int i=0;i<r;i++){
char s[128];
sprintf(s,"%s...%s...%s...",re[c*i],re[c*i+1],re[c*i+2]);
CCLOG(s);
string sql5 ="CREATE TABLE roundsdata(id INTEGER PRIMARY KEY AUTOINCREMENT,type INTEGER, round INTEGER ,rightnum INTEGER,time not null default (datetime('now','localtime')))";
sqliteUtil::createTable(sql5, "roundsdata");
sqliteUtil::insertData("insert into roundsdata(type, round ,rightnum) values(1,1,2)");
sqliteUtil::insertData("insert into roundsdata(type, round ,rightnum) values(1,2,2)");
sqliteUtil::insertData("insert into roundsdata(type, round ,rightnum) values(1,3,2)");
sqliteUtil::insertData("insert into roundsdata(type, round ,rightnum) values(1,4,12)");
sqliteUtil::insertData("insert into roundsdata(type, round ,rightnum) values(2,1,2)");
sqliteUtil::insertData("insert into roundsdata(type, round ,rightnum) values(2,2,2)");
sqliteUtil::insertData("insert into roundsdata(type, round ,rightnum) values(2,3,2)");
sqliteUtil::insertData("insert into roundsdata(type, round ,rightnum) values(2,4,2)");
sqliteUtil::insertData("insert into roundsdata(type, round ,rightnum) values(2,5,2)");
sqliteUtil::insertData("insert into roundsdata(type, round ,rightnum) values(3,1,2)");
sqliteUtil::insertData("insert into roundsdata(type, round ,rightnum) values(3,4,12)");
sqliteUtil::insertData("insert into roundsdata(type, round ,rightnum) values(3,5,2)");
sqliteUtil::insertData("insert into roundsdata(type, round ,rightnum) values(4,1,2)");
sqliteUtil::insertData("insert into roundsdata(type, round ,rightnum) values(4,2,2)");
sqliteUtil::insertData("insert into roundsdata(type, round ,rightnum) values(4,2,12)");
sqliteUtil::insertData("insert into roundsdata(type, round ,rightnum) values(4,3,22)");
tableMes* tablemes = sqliteUtil::getdatas("select A.* from roundsdata A inner join (select max(round) as round,type as type from roundsdata where rightnum<10 group by type) B on A.round=B.round and A.type=B.type limit 3");
char** re = tablemes->getRes();
int r = tablemes->getRow();
int c = tablemes->getCol();
for(int i=0;i<r;i++){
char s[128];
sprintf(s,"%s...%s...%s...",re[c*i],re[c*i+1],re[c*i+2]);
CCLOG(s);