Request DISTINCT records from existing content providers in android

Question

I want great posts from a content provider.

My current code is:

String[] projection= {"_id","address"}; Cursor address = getContentResolver().query(android.provider.Telephony.Sms.Inbox.CONTENT_URI,projection, null, null,"address ASC"); 

Answer 1

You can add the DISTINCT keyword to the column names in the projection. eg.

 String[] projection= {"DISTINCT _id"}; 

Hope this helps you.

Answer 2

// use DISTINCT before the column name

 String[] projection= { "DISTINCT _id", "DISTINCT address"}; Cursor address = getContentResolver().query(android.provider.Telephony.Sms.Inbox.CONTENT_URI,projection, null, null,"address ASC");