思考题:
Oracle的rownum的运用和分析,回答下面的问题:
1.rownum是什么?
有一个表test_a有如下的数据
id tname
1 Lisi
2 Zhangsan
3 William
4 Tom
5 Sammer
6 Zhaoliu
7 Wangwu
8 Liugang
10 Wangmeng
2.请问下面语句的结果分别是多少,请说明理由:
2-1:
select id, tname from test_a where rownum <=5;
2-2:
select id, tname from test_a where rownum > 3 and rownum <8;
2-3:
select id, tname from test_a where rownum = 5;
2-4:
select id, tname from test_a where rownum !=8;
2-5:
select id, tname from test_a where rownum = 1;
解答:
数据库版本:Oracle 11g
--创建表和插入数据
create table test_a(id int,tname varchar2(20));
insert into test_a values(1,'Lisi');
insert into test_a values(2,&