Struggling to get SQL query to work since morning. I am trying to check if particular field has 0 value only for first 500 records.
I tried the following:
SELECT * FROM UnMappText WHERE updateTime = '0' desc LIMIT 0, 500;
This gives me the below error:
Process: com.ylg.dbaccess, PID: 18738
android.database.sqlite.SQLiteException: near "desc": syntax error (code 1): , while compiling: SELECT * FROM UnMappText WHERE updateTime = '0' desc LIMIT 0, 500
at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:889)
at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:500)
at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:58)
at android.database.sqlite.SQLiteQuery.<init>(SQLiteQuery.java:37)
at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:44)
at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1316)
at android.database.sqlite.SQLiteDatabase.rawQuery(SQLiteDatabase.java:1255)
at com.ylg.dbaccess.UnMappText (DBValue.java:3312)
at android.os.Handler.handleCallback(Handler.java:739)
at android.os.Handler.dispatchMessage(Handler.java:95)
at android.os.Looper.loop(Looper.java:135)
at android.app.ActivityThread.main(ActivityThread.java:5254)
at java.lang.reflect.Method.invoke(Native Method)
at java.lang.reflect.Method.invoke(Method.java:372)
at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:903)
at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:698)
So I tried the following way:
SELECT * FROM UnMappText WHERE updateTime = '0' ORDER By updateTime LIMIT 0, 500;
This gives me a result but doesn't give result for first 500 records but just gives 500 records results.
How do I get to check updateTime has 0 for first 500 records?
Aucun commentaire:
Enregistrer un commentaire