select record_time, record_content from( select *, if(@ct = substring(tmp1.record_time,1,10), @rank:=@rank+1, @rank:= 1) rank, @ct:=substring(tmp1.record_time,1,10) from (select @rank=0, record_time,record_content from tableName order by record_time desc) tmp1) tmp2 where rank <=5
56,687
社区成员
56,710
社区内容
加载中
试试用AI创作助手写篇文章吧