Android SQLite Commands with Group By and HAVING

 SELECT * from survey_answer_list_main

SELECT question_id,answer, count(answer)  from survey_answer_list_main where survey_id=1 AND type='single'  group by question_id,answer;

SELECT question_id,answer, count(answer)  from survey_answer_list_main where survey_id=1 AND type='single'  group by question_id,answer having answer LIKE '%yes%'

Custom Spinner background

http://www.gersic.com/blog.php?id=57

Multi-Selection ListView ANDROID with CheckBox

Multi selection

http://dj-android.blogspot.in/2012/04/milti-selection-listview-android-with.html

To get the selected rows

del_selected.setOnClickListener(new OnClickListener() {

@Override
public void onClick(View v) {
SavelistAdapter sladapt=(SavelistAdapter) list_save.getAdapter();
String inarray="(";
for(int i=0;i<sladapt.getCount();i++){
mItem=sladapt.getItem(i);
if(nm.isChecked()){
inarray+=""+nm.getId()+",";
}

}
inarray=inarray.substring(0, inarray.length()-1)+")";
Log.i("zacharia", "i ="+inarray);
}

});

SQLite Commands

VACUUM- to reduce the db size

db.execSQL("VACUUM");


In query: