id_, type_, question_, group_flag_, right_option_, difficulty_, parsing_, mark_type_, memo_, sn_, is_dele_, create_by_, create_org_id_, create_time_, update_by_, update_time_ SELECT q.* FROM exam_questions_info q WHERE q.type_ = #{questionType} and q.sub_id_ = #{subjectId} and q.is_dele_ ='0' ORDER BY random() LIMIT #{numuber} SELECT y.*, s.id_, s.name_ AS subjectName FROM exam_subject_info s inner JOIN ( SELECT q.sub_id_, q.type_, min(q.score_) as score, COUNT ( 0 ) AS COUNT FROM exam_questions_info q WHERE q.sub_id_ = #{subjectId} and q.is_dele_ ='0' GROUP BY q.type_, q.sub_id_ ORDER BY q.type_ desc ) y ON y.sub_id_ = s.id_ SELECT DISTINCT q.*,s.name_ as subjectName FROM exam_questions_info q LEFT JOIN exam_subject_info s on s.id_ = q.sub_id_ LEFT JOIN exam_subject_pos ps on ps.subject_id_ = s.id_ ${ew.customSqlSegment} SELECT q.type_, COUNT ( 0 ) AS COUNT FROM exam_questions_info q WHERE q.is_dele_ = '0' GROUP BY q.type_ ORDER BY q.type_ asc SELECT q.difficulty_ as difficulty, COUNT ( 0 ) AS COUNT FROM exam_questions_info q WHERE q.is_dele_ = '0' GROUP BY q.difficulty_ ORDER BY q.difficulty_ asc