How to get Last record from Sqlite?

by

I think the top answer is a bit verbose, just use this

SELECT * FROM table ORDER BY column DESC LIMIT 1;

More Related Contents:

  1. get Feature item to list View
  2. When does SQLiteOpenHelper onCreate() / onUpgrade() run?
  3. How to store image in SQLite database
  4. How do I use prepared statements in SQlite in Android?
  5. Where does Android emulator store SQLite database?
  6. Android SQLite Example [closed]
  7. Android database encryption
  8. Android SQLite issue – table … has no column named
  9. How to add new Column to Android SQLite Database?
  10. Android error – close() was never explicitly called on database
  11. Exporting SQLite Database to csv file in android
  12. What is a maximum size of SQLite database on Android?
  13. How to save images into Database
  14. Full text search example in Android
  15. Android ExpandableListView and SQLite Database
  16. Multiple Table SQLite DB Adapter(s) in Android?
  17. select distinct value in android sqlite
  18. A pre-populated database does not work at API 28 throws “no such table” exception
  19. Get last inserted value from sqlite database Android
  20. Could not allocate CursorWindow
  21. When should I do certain SQLite operations on another thread(not the main thread)?
  22. Changing values from Cursor using SimpleCursorAdapter
  23. SQLite exception: Database is locked issue
  24. How can I reset a autoincrement sequence number in sqlite
  25. Sqlite issues with HTC Desire HD
  26. SQLiteOpenHelper – creating database on SD card
  27. difference between rawquery and execSQL in android sqlite database
  28. Get SQLite database from Android app
  29. Does Android SQLite cursor load all records into memory at once?
  30. When to close db connection on android? Every time after your operation finished or after your app exit

Leave a Comment