日期:2014-05-17 浏览次数:20768 次
SQL> select * from teacher order by 1;
NAME LESSONID POSITION
---------- ---------- ---------------
jack 1 professor
jack 3 professor
jack 2 professor
rose 2 vice_professor
rose 1 vice_professor
tom 3 professor
tom 2 professor
tom 1 professor
8 rows selected.
SQL> select * from attestation order by 1;
POSITION LESSONID LESSONPASSSCORE
--------------- ---------- ---------------
professor 3 60
professor 2 80
professor 1 80
vice_professor 1 70
vice_professor 2 70
SQL> select * from result order by 1;
NAME LESSONID SCORE
---------- ---------- ----------
jack 1