创建的几个表:
lijp_clazz表:
CID NAME
---------- ----------
1 java
2 c++
lijp_student表:
SID SNAME CID AGE
---------- ---------- ---------- ----------
11 zhang 1 20
12 liu 2 21
13 chao 1 22
14 li 2 20
15 chao 2 25
16 qiao 2
17 quan 1 19
lijp_lession表:
LID LNAME
---------- ----------
101 english
102 math
103 chinese
lijp_s_l表 :
SID LID SCORE
---------- ---------- ----------
11 101 95
12 102 75
13 103 65
14 101 85
11 102 5
lijp_grade表:
LE LOW HIGH
-- ---------- ----------
a 80 100
b 60 80
c 40 60
d 10 40
代码:
select sid,sname,age from(
select sid,sname,age,rownum r from(
select sid,sname,age
from lijp_student
order by sid)
where rownum<=6)
where rownum>4;
lijp_clazz表:
CID NAME
---------- ----------
1 java
2 c++
lijp_student表:
SID SNAME CID AGE
---------- ---------- ---------- ----------
11 zhang 1 20
12 liu 2 21
13 chao 1 22
14 li 2 20
15 chao 2 25
16 qiao 2
17 quan 1 19
lijp_lession表:
LID LNAME
---------- ----------
101 english
102 math
103 chinese
lijp_s_l表 :
SID LID SCORE
---------- ---------- ----------
11 101 95
12 102 75
13 103 65
14 101 85
11 102 5
lijp_grade表:
LE LOW HIGH
-- ---------- ----------
a 80 100
b 60 80
c 40 60
d 10 40
代码:
select sid,sname,age from(
select sid,sname,age,rownum r from(
select sid,sname,age
from lijp_student
order by sid)
where rownum<=6)
where rownum>4;