我有这样的桌子
|post_date |post |value |
---------------------------------
|2019-11-05|post |text |
|2019-11-05|post |text |
|2019-11-05|post |text |
|2019-11-05|post |text |
|2019-11-06|post |text |
|2019-11-06|post |text |
|2019-11-07|post |text |
|2019-11-08|post |text |
|2019-11-08|post |text |
|2019-11-08|post |text |
|2019-11-08|post |text |
|2019-11-08|post |text |
|2019-11-08|post |text |
我试图选择这样
SELECT post_date,count(*) as post FROM myTable GROUP BY post_date ORDER BY post_date ASC LIMIT 3
它会这样显示
|post_date |post |
-----------------------
|2019-11-05|4 |
|2019-11-06|2 |
|2019-11-07|1 |
我需要像这样的东西
|post_date |post |
-----------------------
|2019-11-06|2 |
|2019-11-07|1 |
|2019-11-08|6 |
它看起来像是极限3的结果。它将从订单中获取最新的3条结果,而不是最早的结果