Select first row from table in SQLiteDatabase - Android Database

Description

Select first row from table in SQLiteDatabase

Demo Code

//package com.java2s;

import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;

public class Main {
    public static Cursor first(SQLiteDatabase db, String name) {
        return db.rawQuery("SELECT id, data FROM " + name + " LIMIT 1;",
                null);//from   ww w.  j  a  va 2s  .com
    }
}

• Previous
• Next

Related Tutorials

• delete database table row By Id
• get Table row Count
• get Max Id by table column name
• fetch All Countries' name from SQLiteDatabase by table name
• fetch Cursor By table name from SQLiteDatabase