select * from (
select tieb_user.username,tieb_tiezi.id,tieb_tiezi.userid,tieb_tiezi.title,tieb_tiezi.content,tieb_tiezi.time,t ieb_tiezi.adminid,tieb_tiezi.cztime,tieb_tiezi.type,rownum ro
from tieb_user,tieb_tiezi
where tieb_user.id=tieb_tiezi.userid and tieb_tiezi.type is not null
order by cztime desc
)
where ro between 5 and 10