What Mark said, you probably meant DISTINCT.
For reference, the Sqlite3 doc on SELECT is here:
http://www.sqlite.org/lang_select.html
Also remember that you have the sqlite3 binary either in SDK/tools or
via adb shell. It can be handy to simulate your select manually once
before you code your
Bin Chen wrote:
> My contacts contain a lot of duplicated records, I want to use the
> traditional SQL clause "UNIQUE" to get the unique records, is it
> doable thru the query() method call? Thanks. I tried with the
> selectionArgs argument but failed.
I am not aware of a UNIQUE clause in queries
2 matches
Mail list logo