就是在view中只有按时间order by STARTDATE_EN DESC;的最近10条,有好的算法 吗?
create view mytemp as select * from (select a.STARTDATE_EN,a.MATCHID,a.HOMETEAMID,b.GAINPOINTS ,a.AWAYTEAMID,(select GAINPOINTS from MATCH_FACT where MATCHID = a.MATCHID and TEAMID = a.AWAYTEAMID) AWAYcount from MATCH_SCHEDULE a,MATCH_FACT b where a.MATCHID = b.MATCHID and a.HOMETEAMID = b.TEAMID order by STARTDATE_EN DESC) where rownum<=10;
select *
from
(select a.STARTDATE_EN,a.MATCHID,a.HOMETEAMID,b.GAINPOINTS ,a.AWAYTEAMID,(select GAINPOINTS from MATCH_FACT where MATCHID = a.MATCHID and TEAMID = a.AWAYTEAMID) AWAYcount
from MATCH_SCHEDULE a,MATCH_FACT b
where a.MATCHID = b.MATCHID and a.HOMETEAMID = b.TEAMID order by STARTDATE_EN DESC)
where rownum<=10;