Using SQLite Select function

I have created a database and all works fine. But How I can get 开发者_如何学运维out last five rows, which one's column value is for example 1.

The select and insert function have synchronized function, so the reading and inserting doesn't happen same time. There has more than 300 hundreds rows, but I only need get cursor object last 5 rows (so I get all columns in one row) which one's column value is 1.

Thanks for any helps!

---

SELECT *                     -- list of the columns you want
  FROM table
 WHERE column1 = 1           -- rows with column1 = 1
 ORDER BY (ordering columns) -- columns by which you want to order
 LIMIT 5                     -- and get the last 5

---

I think you want to select the first five rows which have all have a certain column with a value of one. If so, using a WHERE and LIMIT statement should help:

SELECT * FROM tbl WHERE the_column = 1 LIMIT 5

---

You can Use the method database.query(); as follows:

Cursor cursor = database.query(false, TABLE,new String[] {COLUMNS_TO_SELECT},"YOUR_WHERE_CLAUSE", null, null, null, null /*ORDER BY*/, "5"/*YOUR_LIMIT*/);

Have a look at Documentation