0

this is my rawQuery

WITH authorRating(aname, rating) AS SELECT aname, AVG(quantity) FROM book GROUP BY aname

error is in Logcate

   android.database.sqlite.SQLiteException: near "WITH": syntax error (code 1):
KuLdip PaTel
  • 1,069
  • 7
  • 19

1 Answers1

1

WITH is supported since SQLite 3.8.3, and that is not shipped with all Android versions.

Anyway, this query is not a valid WITH clause, and lacks the actual query.

CL.
  • 173,858
  • 17
  • 217
  • 259
  • Thanks you, you save from me from lots of troubles.i was think that there was error in my code,but now its fine all the things.its works on Android Api level 20 and above. thank you. – KuLdip PaTel Jun 12 '17 at 04:30