select * from (select A.*,rownum rn from (select * from ClientData
c,TransactionData t,GoodsData g,GoodsPhoto gp where 1=1 and
c.clientBH=t.ClientBH and t.TransactionBH=g.TransactionBH and
g.GoodsBH=gp.GoodsBH order by transactionDateTime desc) A where
rownum<=100) where rn>0;
把你的代码嵌套，一段一段执行，找出是哪一个查询结果有问题
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024