- select * from
- ( select ROW_NUMBER() over(order by ue.wzId desc)row,* from
- (select e.title, e.childType as childType,e.content as content,e.rsTime as rsTime,e.id as wzId,u.id as usId,u.face as face,u.nickName as nickName from Essay e
- join Users u
- on e.userId=u.id)ue
-
- ) t
- where row between 1 and 7