56,677
社区成员
发帖
与我相关
我的任务
分享
select t1.id,t1.brandid,t1.n,t1.datetime,t2.id,t2.brandid,t2.n,t2.datetime from
(select * from (select * from test order by datetime desc) as t group by brandid,date(datetime) )t1 join
(select * from (select * from test order by datetime desc) as t group by brandid,date(datetime) )t2
on t1.brandid=t2.brandid
where t1.id<t2.id
写出来了,但是尼玛写成视图的时候提示View's SELECT contains a subquery in the FROM clause的错误,请问你们一般是怎么解决的。