a.id AS "id", a.exam_paper_id AS "examPaperId", a.exam_paper_name AS "examPaperName", a.cosmetology_certificate_level_id AS "cosmetologyCertificateLevelId", a.create_by AS "createBy.id", a.create_date AS "createDate", a.update_by AS "updateBy.id", a.update_date AS "updateDate", a.dt AS "dt", a.remarks AS "remarks", a.del_flag AS "delFlag", a.exam_duration AS "examDuration" groomer_exam_question_bank SELECT FROM groomer_exam_question_bank a WHERE a.id = #{id} SELECT FROM groomer_exam_question_bank a a.del_flag = #{DEL_FLAG_NORMAL} ORDER BY ${page.orderBy} ORDER BY a.update_date DESC SELECT FROM groomer_exam_question_bank a a.del_flag = #{DEL_FLAG_NORMAL} ORDER BY ${page.orderBy} ORDER BY a.update_date DESC INSERT INTO groomer_exam_question_bank( id, exam_paper_id, exam_paper_name, cosmetology_certificate_level_id, create_by, create_date, update_by, update_date, dt, remarks, del_flag, exam_duration ) VALUES ( #{id}, #{examPaperId}, #{examPaperName}, #{cosmetologyCertificateLevelId}, #{createBy.id}, #{createDate}, #{updateBy.id}, #{updateDate}, #{dt}, #{remarks}, #{delFlag}, #{examDuration} ) UPDATE groomer_exam_question_bank SET exam_paper_id = #{examPaperId}, exam_paper_name = #{examPaperName}, cosmetology_certificate_level_id = #{cosmetologyCertificateLevelId}, update_by = #{updateBy.id}, update_date = #{updateDate}, dt = #{dt}, remarks = #{remarks}, exam_duration = # {examDuration} WHERE id = #{id} UPDATE groomer_exam_question_bank SET del_flag = #{DEL_FLAG_DELETE} WHERE id = #{id} select from a a.cosmetology_certificate_level_id = #{cosmetologyCertificateLevelId} and a.del_flag = '0'