select * from ( SELECT * FROM (select A.*,ROWNUM rn from product A where ROWNUM<4 ) where rn>1 ) p,merchant m where p.merchantId=m.Id;
错误贴出来 select * from ((select A.*,ROWNUM rn from (select * from product) A where ROWNUM<4 ) where rn>1) p,merchant m where p.merchantId=m.Id;where处报缺失右括号 我一直没看懂
错误贴出来 select * from ((select A.*,ROWNUM rn from (select * from product) A where ROWNUM<4 ) where rn>1) p,merchant m where p.merchantId=m.Id;where处报缺失右括号 我一直没看懂select * from (select A.*, ROWNUM rn from product A where ROWNUM < 4) p, merchant m where p.merchantId = m.Id and p.rn > 1;
错误贴出来 select * from ((select A.*,ROWNUM rn from (select * from product) A where ROWNUM<4 ) where rn>1) p,merchant m where p.merchantId=m.Id;where处报缺失右括号 我一直没看懂select * from (select A.*, ROWNUM rn from product A where ROWNUM < 4) p, merchant m where p.merchantId = m.Id and p.rn > 1; 跟楼上一样。这条sql查出来的值对了 但是2条值都分别重复了11次 现在现在22条值
SELECT * FROM (select A.*,ROWNUM rn from product A where ROWNUM<4 ) where rn>1
) p,merchant m
where p.merchantId=m.Id;
select * from ((select A.*,ROWNUM rn from (select * from product) A where ROWNUM<4 ) where rn>1) p,merchant m where p.merchantId=m.Id;where处报缺失右括号 我一直没看懂
select * from ((select A.*,ROWNUM rn from (select * from product) A where ROWNUM<4 ) where rn>1) p,merchant m where p.merchantId=m.Id;where处报缺失右括号 我一直没看懂select *
from (select A.*, ROWNUM rn from product A where ROWNUM < 4) p,
merchant m
where p.merchantId = m.Id
and p.rn > 1;
select * from ((select A.*,ROWNUM rn from (select * from product) A where ROWNUM<4 ) where rn>1) p,merchant m where p.merchantId=m.Id;where处报缺失右括号 我一直没看懂select *
from (select A.*, ROWNUM rn from product A where ROWNUM < 4) p,
merchant m
where p.merchantId = m.Id
and p.rn > 1;
跟楼上一样。这条sql查出来的值对了 但是2条值都分别重复了11次 现在现在22条值