河南网站建设公司|河南网站建设价格费用_北京今天最新新闻_网站收录情况查询_品牌运营公司

SELECT * FROM (

SELECT *,

@rank := IF(@current_day = DATE(your_date_column), @rank + 1, 1) AS rank,

@current_day := DATE(your_date_column)

FROM your_table_name

JOIN (SELECT @current_day := NULL, @rank := 0) AS init

ORDER BY DATE(your_date_column), your_order_column

) AS t

WHERE t.rank <= 3;