- SELECT
- *
- FROM
- (
- SELECT
- t.store_id,
- t.insert_time,
- IF
- ( @store_id = t.store_id, @ranks := @ranks + 1, @ranks := 1 ) AS ranks,
- @store_id := t.store_id
- FROM
- ( SELECT store_id, insert_time FROM sy_t_advance_order ORDER BY store_id, insert_time DESC ) t,
- ( SELECT @store_id := NULL, @ranks := 0 ) s
- ) dfdf
- WHERE
- ranks = 1