Android SQLite database remove duplicates from query

Question

I'm new to SQLite. I'm using this query in order to extract all rows from a column for a specific user:

        Cursor c = db.query(true, TABLE, COLUMN, USER + "= '" + user + "'", null, null, null, null, null);

This is an example of table:

|group-----ID|
|------------|
|one-------me|
|one------you|
|two-------me|
|one-------me|

So the query for user "me" extracts "one, two, one". How can I filter the result in order to obtain a value just one time? Like "one, two"

Thanks

Sam · Accepted Answer · 2012-12-10 22:23:27Z

5

Use the Group By parameter with the appropriate column name:

Cursor c = db.query(true, TABLE, COLUMN, USER + "= '" + user + "'", null,
            "group", null, null, null);

Since there are nine parameters in this method and three nearly identical methods...

public Cursor query(boolean distinct, 
                    String table, 
                    String[] columns, 
                    String selection, 
                    String[] selectionArgs, 
                    String groupBy,          /* this one */
                    String having, 
                    String orderBy, 
                    String limit)

edited Dec 10, 2012 at 22:23

answered Dec 10, 2012 at 22:18

Sam

87k21 gold badges185 silver badges180 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Android SQLite database remove duplicates from query

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related