mercredi 27 avril 2016

I m geting every Time Random repeting Data in Sqlite android I want Random data without repeting

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