title: Android: Select data from SQLite database - advice
body: <p>Please give me advice, what is the efficient way to select data from database if I have query like <code>SELECT * FROM order_list WHERE order_number = ?</code> In table I have more entries (in my case) with common order number and I'd like to create List for entries with same order number and then shot it in <code>ListView</code>. I don't know if it is efficient first select all order numbers and then in foreach loop select and create <code>List&lt;Item&gt;</code> or exists something better. I've tried find some example but unsuccessfully. How should I solve this problem? Thank you. I appreciate every help.</p>