plsql多表+排序后分页查询

2025-03-23 01:55:35
推荐回答(1个)
回答(1):

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