Android Question Help with SQLite table


Licensed User
Longtime User
Could someone help please

I've got a SQLite database with a table containing 12 columns and about 800 rows.
I need to show 5 of the columns in a list that has to be only 50% of the screen width but I can't show all the columns.
The user needs to be able to select a cell to get the value. I also need to filter and sort the list on any one of 3 of the columns.

I've looked at using Scrollview2D, Webview, Listview etc but I'm confused about which would be the best method.

What would be the most efficient/fastest method to use?