SELECT A.* FROM sp_activity_session A WHERE A.activityId = #{activityId} order by A.startDate delete FROM sp_activity_session WHERE activityId = #{activityId}