create table t8(grade number(8)); insert into t8 values(100); insert into t8 values(45); insert into t8 values(65); insert into t8 values(85); insert into t8 values(90); insert into t8 values(60); insert into t8 values(13); commit; select grade,decode(sign(grade-90+1), 1,'A', decode(sign(grade-75+1), 1,'B', decode(sign(grade-60+1),1,'C','D') ) ) grade_char from t8 order by grade_char,grade; 13:43:36 select">buffsms@TESTA>select grade,decode(sign(grade-90+1), 13:43:49 2 1,'A', 13:43:49 3 decode(sign(grade-75+1), 13:43:49 4 1,'B', 13:43:49 5 decode(sign(grade-60+1),1,'C','D') 13:43:49 6 ) 13:43:49 7 ) grade_char 13:43:49 8 from t8 13:43:49 9 order by grade_char,grade; GRADE GR -------------- -- 90 A 100 A 85 B 60 C 65 C 13 D 45 D 已选择7行。 已用时间: 00: 00: 00.00