经管之家App
让优质教育人人可得
立即打开
| student_id | semester | cred1 | cred2 | cred3 | grade1 | grade2 | grade3 |
| 1 | 1 | 4 | 4 | 0 | A | A- | A |
| 1 | 2 | 4 | 4 | 0 | A | A | A |
| 1 | 3 | 4 | 4 | 0 | A | A- | A |
| 1 | 4 | 4 | 4 | 0 | A | A | A |
| 1 | 5 | 4 | 4 | 0 | A | A | A |
| 1 | 6 | 4 | 4 | 0 | A | A | A |
| 1 | 7 | 4 | 4 | 0 | A | A | A |
| 1 | 8 | 4 | 4 | 0 | A | A | A |
| 2 | 1 | 4 | 3 | 1 | B+ | B+ | B+ |
| 2 | 2 | 4 | 3 | 1 | B | A | A |
| 2 | 3 | 4 | 4 | 0 | A | A- | B+ |
| 2 | 4 | 4 | 4 | 0 | A- | A- | A- |
| 2 | 5 | 4 | 4 | 0 | A- | B+ | A |
| 2 | 6 | 4 | 4 | 0 | A- | A- | B |
| 2 | 7 | 4 | 4 | 0 | B+ | A- | B+ |
| 2 | 8 | 4 | 3 | 1 | A | A- | A |
| 3 | 1 | 4 | 3 | 1 | B- | B- | B- |
| 3 | 2 | 4 | 4 | 0 | B- | C+ | B- |
| 3 | 3 | 4 | 3 | 1 | C+ | B | B |
| 3 | 4 | 4 | 4 | 0 | B- | B | B- |
| 3 | 5 | 4 | 3 | 1 | C+ | C+ | B- |
| 3 | 6 | 3 | 4 | 1 | C+ | B | B |
| 3 | 7 | 3 | 4 | 1 | B | C+ | B |
| 3 | 8 | 4 | 4 | 0 | C | B- | B |
| 4 | 1 | 4 | 4 | 0 | B | C | C+ |
| 4 | 2 | 4 | 4 | 0 | B- | B | B- |
| 4 | 3 | 4 | 3 | 1 | B | B- | C |
| 4 | 4 | 4 | 4 | 0 | B | B | B |
yugao1986 发表于 2011-11-6 19:29
proc sql;
create table need as
select distinct student_id,
扫码加好友，拉您进群
全部版块
我的主页
收藏
