mysql：如何取得按天数十天的记录（不是天数加十天，而是数十天有记录的天）

需求：在预约表中，获得今天以后有预约的，往后数十天的列表

方法一：分页可以加

    	SELECT
		    appointment_id,
		    dw_account_id,
		    clinic_id,
		    account_name,
	    	account_tel,
	    	appointment_date
		FROM
	    	t_appointment
		WHERE
		    appointment_date IN (
		        SELECT
	            	t.appointment_date
	        	FROM
	            	(
		                SELECT
	                    	*
	                	FROM
	                    	t_appointment
	                	and appointment_date >= #{nowDay}
		                GROUP BY
                    		appointment_date
		                ORDER BY
		                appointment_date ASC

			            limit 0, 10
	            	) AS t
		        )
		
		ORDER BY
		appointment_date ASC