我同样的SQL在两个数据库中的结果会不一样,谁能告诉我大概会应为什么?小弟先谢了!
select * from(
select a.rowid,a.error_id,a.error_date,a.resolve_date,b.province_name,c.reason_chn,d.error_chn
from maint.maint_track_error a,ecc_bj.ecc_sv_province b,maint.maint_track_reason c,maint.maint_track_errorcode d
where a.province_id = b.province_id and a.reason_id = c.reason_id(+) and a.errorcode_id = d.errorcode_id
--order by b.province_name,a.error_date desc
) where rowid not in (
select r from( select a.rowid as r,a.error_id,a.error_date,a.resolve_date,b.province_name,c.reason_chn,d.error_chn
from maint.maint_track_error a,ecc_bj.ecc_sv_province b,maint.maint_track_reason c,maint.maint_track_errorcode d
where a.province_id = b.province_id and a.reason_id = c.reason_id(+) and a.errorcode_id = d.errorcode_id
--order by b.province_name,a.error_date desc
) where rownum <= 0 --从第0条记录开始 ) and rownum <= 10 --每页显示10记录
--order by province_name,error_date desc
select * from(
select a.rowid,a.error_id,a.error_date,a.resolve_date,b.province_name,c.reason_chn,d.error_chn
from maint.maint_track_error a,ecc_bj.ecc_sv_province b,maint.maint_track_reason c,maint.maint_track_errorcode d
where a.province_id = b.province_id and a.reason_id = c.reason_id(+) and a.errorcode_id = d.errorcode_id
--order by b.province_name,a.error_date desc
) where rowid not in (
select r from( select a.rowid as r,a.error_id,a.error_date,a.resolve_date,b.province_name,c.reason_chn,d.error_chn
from maint.maint_track_error a,ecc_bj.ecc_sv_province b,maint.maint_track_reason c,maint.maint_track_errorcode d
where a.province_id = b.province_id and a.reason_id = c.reason_id(+) and a.errorcode_id = d.errorcode_id
--order by b.province_name,a.error_date desc
) where rownum <= 0 --从第0条记录开始 ) and rownum <= 10 --每页显示10记录
--order by province_name,error_date desc
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货