数据库的整理

关于最大数的查询

通过最大数查询符合的行

String sql1 = "select MAX(" + Contacts.STUDENT_SCORE + ") from " + Contacts.DB_TABLE_NAME;String sql = "select * from " + Contacts.DB_TABLE_NAME + " where " + Contacts.STUDENT_SCORE + " = (" + sql1 + ")";Cursor cursor = db.rawQuery(sql, null);if (cursor != null)    while (cursor.moveToNext()) {        String name = cursor.getString(cursor.getColumnIndex(Contacts.STUDENT_NAME));        int score = cursor.getInt(cursor.getColumnIndex(Contacts.STUDENT_SCORE));        StudentBean p = new StudentBean(name, score);        personBeans.add(p);    }