How to make... SQLite select DISTINCT -> query(true, ...)

Question

My query is:

String _query = "select DISTINCT Y.CATE_CODE4 CATE_CODE, Y.CATE_NAME4 CATE_NAME,
                 0 IS_PRESET from G_MASTER X INNER JOIN CATEGORY_VIEW Y ON X.CATE_4 = Y.CATE_CODE4
                 where X.IS_SALE = 1 AND Y.IS_LOCKED4 = 0 AND Y.CATE_NAME2 not in ('XXXX')";

How does Android SQLite make db.query()?

my query have..., DISTINCT keyword...T.T db.rawQuery() not working .. — taejun, Mar 17 '15 at 11:09
... so what? http://www.tutorialspoint.com/sqlite/sqlite_distinct_keyword.htm **Who told you** that `rawQuery()` can't do something that `query()` can? — Phantômaxx, Mar 17 '15 at 11:10
http://stackoverflow.com/questions/11219361/select-distinct-value-in-android-sqlite android sqlite ... — taejun, Mar 17 '15 at 11:14
FWIW, all `query()` does is that it constructs an SQL string and feeds it to `rawQuery()`. Don't believe everything you read online. — laalto, Mar 17 '15 at 11:18
By the way, I had dinner with Santa Claus, yesterday evening. — Phantômaxx, Mar 17 '15 at 11:20

Skizo-ozᴉʞS ツ · Accepted Answer · 2015-03-17T11:22:50.480

2

First of all you should read SQLiteDatabase reference.

You could use a rawQuery(), here's an example of it :

rawQuery - db.rawQuery("select DISTINCT Y.CATE_CODE4 CATE_CODE, Y.CATE_NAME4 CATE_NAME,
             0 IS_PRESETG_MASTER X INNER JOIN CATEGORY_VIEW Y ON X.CATE_4 = Y.CATE_CODE4 from table where X.IS_SALE = 1 AND Y.IS_LOCKED4 = 0 AND Y.CATE_NAME2 not in ('XXXX')"",new String[]{"data"});

It's just an example, you have to adapt your code to this.

edited Mar 17 '15 at 11:22

answered Mar 17 '15 at 11:12

Skizo-ozᴉʞS ツ

19,464
18
81
148

String _query = "select DISTINCT Y.CATE_CODE4 CATE_CODE, Y.CATE_NAME4 CATE_NAME, 0 IS_PRESET from G_MASTER X INNER JOIN CATEGORY_VIEW Y ON X.CATE_4 = Y.CATE_CODE4 where X.IS_SALE = 1 AND Y.IS_LOCKED4 = 0 AND Y.CATE_NAME2 not in ('XXXX')"; Cursor cursor = mDb.rawQuery(_query, null); it doesn't woking...T.T – taejun Mar 17 '15 at 11:26
3

I told you it was just an example how to do it... not the solution. – Skizo-ozᴉʞS ツ Mar 17 '15 at 11:27

How to make... SQLite select DISTINCT -> query(true, ...)

1 Answers1