select * from ( select c.T_id, c.t_classname, to_char(c.T_BEGIN_TIME,'YYYY-MM-DD') begin_date, c.t_fee, p.URL_GEN, s.city_name, t.t_name class_type from t_fl_class c, v_igo99_class_prop p, t_company_city s, t_fl_class_type t where c.t_city_id=s.company_id and c.t_id=p.id and c.t_status=0 and c.t_is_show_index=0 and c.t_class_type_id = t.t_id and t_course_type_id=? and (c.T_BEGIN_TIME >=sysdate -1 or T_BEGIN_TIME is null ) order by c.T_BEGIN_TIME ASC ) where rownum <=11