为什么下面两个分页语句查询出来的记录都会有msisdn = 13407711511的记录;
其中test_a ,dim_home_area 表都没有重复的数据select * from (
select *
from (select row_.*, rownum rownum_
from (select a.msisdn,a.name,a.home_county
FROM test_a a
WHERE a.home_county in (select home_area_code from dim_home_area where (home_area_group_code = '771'))
order by a.home_county) row_
where rownum < 120001
)
where rownum_ >= 60001
) where msisdn in (13407711511) ;
select * from (
select *
from (select row_.*, rownum rownum_
from (select a.msisdn,a.name,a.home_county
FROM test_a a
WHERE a.home_county in (select home_area_code from dim_home_area where (home_area_group_code = '771'))
order by a.home_county) row_
where rownum < 60001
)
where rownum_ >= 1
) where msisdn in (13407711511) ;
其中test_a ,dim_home_area 表都没有重复的数据select * from (
select *
from (select row_.*, rownum rownum_
from (select a.msisdn,a.name,a.home_county
FROM test_a a
WHERE a.home_county in (select home_area_code from dim_home_area where (home_area_group_code = '771'))
order by a.home_county) row_
where rownum < 120001
)
where rownum_ >= 60001
) where msisdn in (13407711511) ;
select * from (
select *
from (select row_.*, rownum rownum_
from (select a.msisdn,a.name,a.home_county
FROM test_a a
WHERE a.home_county in (select home_area_code from dim_home_area where (home_area_group_code = '771'))
order by a.home_county) row_
where rownum < 60001
)
where rownum_ >= 1
) where msisdn in (13407711511) ;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货