[Solved] How to get recent added three data FROM SQLite

Question

You can use limit in your query which will return the n (n is the number of the row you want to fetch) row.

String selectQuery = "SELECT  * FROM " + COMPANY + " ORDER BY (" + KEY_CREATED_AT + ") DESC LIMIT 3 " ;

Accepted Answer

You can use limit in your query which will return the n (n is the number of the row you want to fetch) row.

String selectQuery = "SELECT  * FROM " + COMPANY + " ORDER BY (" + KEY_CREATED_AT + ") DESC LIMIT 3 " ;