教程表的最后五条记录
是用select * from
(select instrid,instrname from catainf order by instrid desc) a
不是select instrid,instrname from catainf where rownum<=5 order by instrid deschave a try:
select instrid,instrname from
(select instrid,instrname from catainf order by instrid desc) a
where rownum<=5
union all
select select softid,softname
from ( select select softid,softname from catasoft order by softid desc) b where rownum<=5;
是用select * from
(select instrid,instrname from catainf order by instrid desc) a
不是select instrid,instrname from catainf where rownum<=5 order by instrid deschave a try:
select instrid,instrname from
(select instrid,instrname from catainf order by instrid desc) a
where rownum<=5
union all
select select softid,softname
from ( select select softid,softname from catasoft order by softid desc) b where rownum<=5;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货