SELECT * FROM ( SELECT *, (SELECT COUNT(*) FROM TB T2 WHERE T1.UID = T2.UID AND T1.PICID <= T2.PICID) RN FROM TB T1 )T WHERE RN <= 4
select * from table where uid = '' order by picid limit 4
select * from tb A where 4>=(select count(*) from tb B where A.uid=B.uid and A.uid<B.uid)
56,675
社区成员
56,706
社区内容
加载中
试试用AI创作助手写篇文章吧