改成 select * from tablename desc limit 0,9 就可以了
比如
// 获取前十条记录
public List<Payment> GetPayListTopTen() {
List<Payment> userList = new ArrayList<Payment>();
Cursor cursor = db.rawQuery("select * from account desc limit 0,9", null);
cursor.moveToFirst();
while (!cursor.isAfterLast() && (cursor.getString(1) != null)) {
Payment pay = new Payment();
pay.setId(cursor.getInt(0));
pay.setMoney(cursor.getString(1));
pay.setText(cursor.getString(2));
pay.setTime(cursor.getString(3));
userList.add(pay);
cursor.moveToNext();
}
cursor.close();
return userList;
}