Android: Get specific rows from database

Question

I have a database of about 200 rows and i was wondering how to get rows from ids 50 to 75. Im using the following code to retrieve all the rows from the database.

SQLiteDatabase db = this.getWritableDatabase();
     String selectQuery = "SELECT  * FROM " + TABLE_DETAILS;
     try {
         Cursor cursor = db.rawQuery(selectQuery, null);
         try {
             if (cursor.moveToFirst()) {
                 do {
                    Log.d("Data", cursor.getString(1));
                        Log.d("Data", cursor.getString(3)));
                    Log.d("Data", cursor.getString(4)));
                    Log.d("Data", cursor.getString(5)));
                 } while (cursor.moveToNext());
             }

         } finally {
             try {
                 cursor.close(); 
             } catch (Exception ignore) {

             }
         }
     } finally {
         try {
             db.close();
         } catch (Exception ignore) {

         }
     }

Thanks, Sahil

Shayan Pourvatan · Accepted Answer · 2014-06-28 05:45:34Z

1

you can use where statement like:

 WHERE ids >= 50 AND ids <= 75

answered Jun 28, 2014 at 5:45

Shayan Pourvatan

11.9k4 gold badges44 silver badges63 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Gabe Sechan Over a year ago

Upvoting, but I think the variable is called ROWID instead of ids. Or maybe it can go by both, I know SQLite does some aliasing there.

Shayan Pourvatan Over a year ago

thanks @GabeSechan, I have use ids because OPs statement : "how to get rows from ids 50 to 75" , i thought that one column in table is ids.

Collectives™ on Stack Overflow

Android: Get specific rows from database

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related