I m Getting Many Time Repeting data from Sqlite /Android DataBase I wnat to get Recode without repeting In android cursor Please Help And Sorry For Englis
her's My quiry
public Cursor getQuizQuiestion(String cat,String level,String questionNo){
String QUERY_SELECT_QUIESTION = "SELECT * FROM " +TABLE_QUIESTION +" WHERE "+COL_CAT+ " = '" +cat+"' AND "
+COL_LEVEL+ " = " +level+" ORDER BY RANDOM() LIMIT 1";
Cursor cursor = db.rawQuery(QUERY_SELECT_QUIESTION, null);
return cursor;
}
Aucun commentaire:
Enregistrer un commentaire