select *
from
(
select b.name,a.title,a.content,a.adddate,
row_number() over(partition by b.name order by a.adddate desc) rn
from news a,sort b
where a.sortid=b.id
)
where rn < 6
select *
from
(
select a.*,b.name,row_number() over(partition by a.sortid order by a.adddate asc) rn
from news a,sort b
where a.sortid=b.id
)
where rn<=5
;