[android-developers] Re: Can I use UNIQUE in the query() parameter?

2009-04-12 Thread Mark Murphy
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 in

[android-developers] Re: Can I use UNIQUE in the query() parameter?

2009-04-12 Thread Ralf
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