在一个表中插入了这些数据,
insert into nssrf_group__menu t(t.group_sid,t.menu_id)
select '104189101%',430 from dual
union
select '104189100%',430 from dual
union
select '104189102%',430 from dual
union
select '104189103%',430 from dual
union
select '104189104%',430 from dual
union
select '104189105%',430 from dual
union
select '104189106%',430 from dual
union
select '104189107%',430 from dual
union
select '104189108%',430 from dual
union
select '104189109%',430 from dual
然后通过select * from nssrf_group__menu t where t.menu_id = 430 查询 结果只查到了8条数据,但是这样查的话就全部显示出来了
select distinct * from nssrf_group__menu t where t.menu_id = 430
insert into nssrf_group__menu t(t.group_sid,t.menu_id)
select '104189101%',430 from dual
union
select '104189100%',430 from dual
union
select '104189102%',430 from dual
union
select '104189103%',430 from dual
union
select '104189104%',430 from dual
union
select '104189105%',430 from dual
union
select '104189106%',430 from dual
union
select '104189107%',430 from dual
union
select '104189108%',430 from dual
union
select '104189109%',430 from dual
然后通过select * from nssrf_group__menu t where t.menu_id = 430 查询 结果只查到了8条数据,但是这样查的话就全部显示出来了
select distinct * from nssrf_group__menu t where t.menu_id = 430
SQL>
SQL> with nssrf_group__menu as(
2 select '104189101%'group_sid,430 menu_id from dual
3 union
4 select '104189100%',430 from dual
5 union
6 select '104189102%',430 from dual
7 union
8 select '104189103%',430 from dual
9 union
10 select '104189104%',430 from dual
11 union
12 select '104189105%',430 from dual
13 union
14 select '104189106%',430 from dual
15 union
16 select '104189107%',430 from dual
17 union
18 select '104189108%',430 from dual
19 union
20 select '104189109%',430 from dual
21 )
22 select * from nssrf_group__menu t where t.menu_id = 430
23 ;
GROUP_SID MENU_ID
---------- ----------
104189100% 430
104189101% 430
104189102% 430
104189103% 430
104189104% 430
104189105% 430
104189106% 430
104189107% 430
104189108% 430
104189109% 430
10 rows selected
SQL>
是否是在pl/sql dev的sql窗口中,查询时只显示了前8条,点fetch last page就出来了
15:01:24 sys@PRACTICE> insert into nssrf_group__menu t(t.group_sid,t.menu_id)
15:01:31 2 select '104189101%',430 from dual
15:01:31 3 union
15:01:31 4 select '104189100%',430 from dual
15:01:31 5 union
15:01:31 6 select '104189102%',430 from dual
15:01:31 7 union
15:01:31 8 select '104189103%',430 from dual
15:01:31 9 union
15:01:31 10 select '104189104%',430 from dual
15:01:31 11 union
15:01:31 12 select '104189105%',430 from dual
15:01:31 13 union
15:01:31 14 select '104189106%',430 from dual
15:01:31 15 union
15:01:31 16 select '104189107%',430 from dual
15:01:31 17 union
15:01:31 18 select '104189108%',430 from dual
15:01:31 19 union
15:01:31 20 select '104189109%',430 from dual;已创建10行。已用时间: 00: 00: 00.00
15:01:33 sys@PRACTICE> select * from nssrf_group__menu t where t.menu_id = 430;GROUP_SID MENU_ID
-------------------- ----------
104189100% 430
104189101% 430
104189102% 430
104189103% 430
104189104% 430
104189105% 430
104189106% 430
104189107% 430
104189108% 430
104189109% 430已选择10行。已用时间: 00: 00: 00.01
15:01:48 sys@PRACTICE> select distinct * from nssrf_group__menu t where t.menu_id = 430;GROUP_SID MENU_ID
-------------------- ----------
104189100% 430
104189104% 430
104189105% 430
104189106% 430
104189107% 430
104189103% 430
104189101% 430
104189102% 430
104189108% 430
104189109% 430已选择10行。已用时间: 00: 00: 00.01