select distinct value in android sqlite

by

But you MUST remember to send argument in GROUPBY (NOT NULL send).

You must give column name for distinct.

Example:

Cursor cursor = db.query(true, YOUR_TABLE_NAME, new String[] { COLUMN_NAME_1 ,COLUMN_NAME_2, COLUMN_NAME_3 }, null, null, COLUMN_NAME_2, null, null, null);

true – distinct TRUE

COLUMN_NAME_2 – name column what you have be DISTINCT.

That’s works for me fine.

More Related Contents:

  1. get Feature item to list View
  2. When does SQLiteOpenHelper onCreate() / onUpgrade() run?
  3. How to store image in SQLite database
  4. How do I use prepared statements in SQlite in Android?
  5. Android SQLite database: slow insertion
  6. Where does Android emulator store SQLite database?
  7. Android SQLite Example [closed]
  8. Android database encryption
  9. How to escape special characters like ‘ in sqlite in android
  10. Use a local database in Xamarin
  11. Android SQLite issue – table … has no column named
  12. How to add new Column to Android SQLite Database?
  13. Android error – close() was never explicitly called on database
  14. What is a Full Android Database Helper class for an existing SQLite database? [closed]
  15. Exporting SQLite Database to csv file in android
  16. What is a maximum size of SQLite database on Android?
  17. How to save images into Database
  18. Full text search example in Android
  19. How to get Last record from Sqlite?
  20. rawQuery(query, selectionArgs)
  21. A pre-populated database does not work at API 28 throws “no such table” exception
  22. Get last inserted value from sqlite database Android
  23. Could not allocate CursorWindow
  24. When should I do certain SQLite operations on another thread(not the main thread)?
  25. Changing values from Cursor using SimpleCursorAdapter
  26. SQLite exception: Database is locked issue
  27. How can I reset a autoincrement sequence number in sqlite
  28. Sqlite issues with HTC Desire HD
  29. Compare dates (stored as string) in android sqlite database?
  30. H2 Database vs SQLite on Android [closed]

Leave a Comment