mysql 语句练习

最新推荐文章于 2025-09-13 19:07:06 发布

转载最新推荐文章于 2025-09-13 19:07:06 发布 · 48 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/flex_fly/archive/2012/02/06/2340211.html

文章标签：

#数据库

     SELECT * FROM (

                              SELECT bb.* FROM (SELECT dt.action_id, dt.order_id, oa2.shipping_status FROM   (

                   SELECT oa.* FROM t_order_action oa WHERE
                        oa.log_time >= UNIX_TIMESTAMP('2012-01-09 00:00:00') - (3600 * 8)
                        AND oa.log_time < UNIX_TIMESTAMP('2012-01-10 00:00:00')- (3600 * 8)
                   AND action_note LIKE '%分配给1110%'
                   GROUP BY oa.order_id ) AS dt

                   JOIN t_order_action oa2 ON oa2.order_id = dt.order_id ORDER BY oa2.action_id DESC ) AS bb
                   GROUP BY bb.order_id ) AS cc
               WHERE cc.shipping_status = 13

转载于:https://www.cnblogs.com/flex_fly/archive/2012/02/06/2340211.html