select groupType, groupCode, code, name from t_code order by groupType asc, code*1 asc select groupType, groupCode, code, name from t_code where groupType = #{groupType} order by code*1 asc select groupType, count(code) count from t_code group by groupType order by code*1 asc