Mysql检查。按不同日期“同店销售”记录一天

可以实现对表或子表中相同过滤数据的联接。

工业工程

 select tdate.store_id  ,(tdate.revenue - ydate.revenue) as diffrence 
 from (select store_id ,revenue from tablename where stats_date =getdata()) tdate 
   join ( select store_id ,revenue from tablename  where stats_date = DATEADD(day, -1,getdata()) )  as ydate
  on tdate.store_id = ydate.store_id

注:

更新昨天的筛选数据

tdate筛选昨天的数据

可以添加更多筛选条件。

或者你在找

 select tdate.store_id  ,(tdate.revenue - ydate.revenue) as diffrence 
   from  tablename tdate 
   join tablename   as ydate
    on tdate.store_id = ydate.store_id
    and tdate.stats_date =ydate.DATEADD(day, -1,stats_date)