How to return unique rows within a column in Android SQLite?

Question

Really all I want to do is say the query SELECT DISTINCT column FROM table but I can't figure out how to structure it in the enourmous query methods that are part of SQLiteDatabase

I'm just trying to get the names of all contacts in a table.

Are you having trouble with the SQL statement or with the API? — Ted Hopp
– Ted Hopp, Commented Mar 20, 2011 at 5:34
The API. I believe the statement I want is SELECT DISTINCT column FROM table. — eternalmatt
– eternalmatt, Commented Mar 20, 2011 at 5:35

f20k · Accepted Answer · 2011-03-20 05:36:54Z

6

You seem to know the sql query you want to run. Have you tried using rawQuery()?

answered Mar 20, 2011 at 5:36

f20k

3,1063 gold badges26 silver badges32 bronze badges

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

2 Comments

eternalmatt Over a year ago

This is exactly it; I've tested it and it works how I want it. Are there any advantages to "query" over "rawQuery" as Ted Hopp suggested I use.

f20k Over a year ago

Sorry I do not know if there is any advantage to using query over rawQuery. However I would recommend using rawQuery if you know SQL because it's easier to read and you don't to memorize the order of the parameters.

Ted Hopp · Accepted Answer · 2011-03-20 05:38:56Z

1

You will probably find this version of the SQLiteDatabase#query method most useful.

answered Mar 20, 2011 at 5:38

Ted Hopp

235k48 gold badges413 silver badges533 bronze badges

1 Comment

eternalmatt Over a year ago

This is actually what's giving me problems. @f20k might have what I need.

Collectives™ on Stack Overflow

How to return unique rows within a column in Android SQLite?

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related