SQL 从一个sql 语句结果中（作为AS一个表） 查询结果 ；按照count排序

从  一个sql 语句中查找另一个sql语句查询的结果：

	public void  getSumCountgsMebDTO1(int memberSum){
		
		SQLiteDatabase db = helper.getReadableDatabase();
		String COUNT_NUM="COUNT_NUM";
		
		String sql1 ="select * from "+ "(select  "+DBConstants.DB_SEND_GROUP_MB_groupsendid+","
				+ " count("+DBConstants.DB_SEND_GROUP_MB_groupsendid+ ") "
				+ " as "+ COUNT_NUM
				+ " from " + DBConstants.DB_SEND_GROUP_MB
				+ " group by "+DBConstants.DB_SEND_GROUP_MB_groupsendid+") as tabl2 "//内部用不了COUNT_NUM，外部可以使用
				+ " where tabl2.COUNT_NUM = "+3;
//		String sql1 = "select  "+DBConstants.DB_SEND_GROUP_MB_groupsendid+","
//				+ " count("+DBConstants.DB_SEND_GROUP_MB_groupsendid+ ") "
//				+ " as "+ COUNT_NUM
//				+ " from " + DBConstants.DB_SEND_GROUP_MB
//				+ " group by "+DBConstants.DB_SEND_GROUP_MB_groupsendid
//				+ " order by "+ " count("+DBConstants.DB_SEND_GROUP_MB_groupsendid+ ") "+"  desc";
		
		Cursor cursor  = db.rawQuery(sql1, null);
		
		MyLog.e(TAG, " getSumCountgsMebDTO cursor.count =  "+cursor.getCount());
		StringBuffer sb=new StringBuffer();
		while (cursor.moveToNext()) {
			int num = cursor.getInt(cursor.getColumnIndex(COUNT_NUM));
//			String memberNum = cursor.getString(cursor.getColumnIndex(DBConstants.DB_SEND_GROUP_MB_membernumber));
			String groupsendid = cursor.getString(cursor.getColumnIndex(DBConstants.DB_SEND_GROUP_MB_groupsendid));
			
			sb.append(" getSumCountgsMebDTO result = "
//			+ memberNum +"  "
					+groupsendid
					+" = "+num
					+";\n");
		}
		MyLog.e(TAG, sb.toString());
	}

=============获取 某列 在从sqlite语句中查询的结果的cursor当中，===============================================================

/**按照群发组分类： 每个群发组有多少成员；*/
	public void  getSumCountgsMebDTO(ArrayList<GroupSendMemberDTO> gsmdtos){
	/**
	 * 分析：
	 * 1.gsmdtos 就是当前的群发的成员结果集合；
	 * 2.如果gsmdtos  不包含cursor.get(index),则去除这个groupSendid（将其纪录下来，下次的groupSendid包含则跳过）
	 * 3.如果都包含，则去取出这个groupSendid
	 * 4.通过groupsendid，查询groupSenddto，和groupsendMsg
	 */		
		if (gsmdtos==null||gsmdtos.size()<1) {
			throw new IllegalArgumentException(" getSumCountgsMebDTO2(ArrayList<GroupSendMemberDTO> gsmdtos) 的gsmdto 的参数异常");
		}
		SQLiteDatabase db = helper.getReadableDatabase();
		String COUNT_NUM="COUNT_NUM";
		String TABLE2="TABLE2";
		
		String sql1 =
				"select * from " + DBConstants.DB_SEND_GROUP_MB+ " where "+DBConstants.DB_SEND_GROUP_MB_groupsendid+" in "
					+"(select "+DBConstants.DB_SEND_GROUP_MB_groupsendid+" from "
						+ "(select "+DBConstants.DB_SEND_GROUP_MB_groupsendid+","
						+ " count("+DBConstants.DB_SEND_GROUP_MB_groupsendid+ ") "
						+ " as "+ COUNT_NUM
						+ " from " + DBConstants.DB_SEND_GROUP_MB
						+ " group by "+DBConstants.DB_SEND_GROUP_MB_groupsendid+") as "+TABLE2//内部用不了COUNT_NUM，外部可以使用
					+ " where "+TABLE2+"."+COUNT_NUM+" = "+gsmdtos.size()+" ) ";
//		String sql1 = "select  "+DBConstants.DB_SEND_GROUP_MB_groupsendid+","
//		+ " count("+DBConstants.DB_SEND_GROUP_MB_groupsendid+ ") "
//		+ " as "+ COUNT_NUM
//		+ " from " + DBConstants.DB_SEND_GROUP_MB
//		+ " group by "+DBConstants.DB_SEND_GROUP_MB_groupsendid
//		+ " order by "+ " count("+DBConstants.DB_SEND_GROUP_MB_groupsendid+ ") "+"  desc";
		Cursor cursor  = db.rawQuery(sql1, null);
		
		ArrayList<String> cursorGrpSendIds=new ArrayList<String>();
		MyLog.e(TAG, " getSumCountgsMebDTO cursor.count =  "+cursor.getCount());
		StringBuffer sb=new StringBuffer();
		while (cursor.moveToNext()) {
			String memberNum = cursor.getString(cursor.getColumnIndex(DBConstants.DB_SEND_GROUP_MB_membernumber));
			String groupsendid = cursor.getString(cursor.getColumnIndex(DBConstants.DB_SEND_GROUP_MB_groupsendid));
			
			sb.append(" getSumCountgsMebDTO result = "
								+groupsendid
									+" = "+memberNum
								+";\n");
		}
		MyLog.e(TAG, sb.toString());
	}