select * from
(
select rownum rid,b.*,c.type from nsos.nlusr_news b,nsos.nlusr_type c where b.type=c.typeid and b.type='55' and rownum<=2
) where rm>0 ;
(
select rownum rid,b.*,c.type from nsos.nlusr_news b,nsos.nlusr_type c where b.type=c.typeid and b.type='55' and rownum<=2
) where rm>0 ;
(
select rownum rm,b.*,c.type from nsos.nlusr_news b,nsos.nlusr_type c where b.type=c.typeid and b.type='55' and rownum <=2
) where rm >0 ;
(
select rownum rm,b.*,c.type from nsos.nlusr_news b,nsos.nlusr_type c where b.type=c.typeid and b.type='55' and rownum <=2
) a where rm >0
这样也不行
表结构:nsos.nlusr_news
newid title type parent subject dateTime src roll creator des image mimensos.nlusr_type:
typeid type parent
( select rownum rm,b.*,c.type ctype from nsos.nlusr_news b,nsos.nlusr_type c where b.type=c.typeid and b.type='55' and rownum<=2
) a where rm>0;
搞到自己也不知select 了那些字段.
select a.* from
( select rownum rm,b.*,c.type ctype from nsos.nlusr_news b,nsos.nlusr_type c where b.type=c.typeid and b.type='55' and rownum<=2
) a where rm>0;