已知表结构如下:
sno |
cno | score |
---|---|---|
s001 | c001 | 80 |
s001 | c002 | 90 |
s002 | c001 | 79 |
s002 | c002 | 85 |
s003 | c001 | 79 |
s003 | c002 | 80 |
1. ROWNUM
1.1 rownum 是一个序列,是oracle数据库从数据文件或缓存中读取数据的顺序, 如:
select * from sc where rownum = 1
结果返回SC表的第一行数据
sno |
cno | score |
---|---|---|
s001 | c001 | 80 |
1.2 select rownum是在查询结果中插入“伪列&