mysql查询指定月份范围内,每个月的指定id下的数据量

2025-03-12 08:51:15
推荐回答(1个)
回答1:

您好,
SELECT art_id, art_pdate
FROM ecos_article
WHERE art_id>75 limit 0,1
UNION
SELECT art_id, art_pdate
FROM ecos_article
WHERE art_id<=75 ORDER BY art_id DESC limit 0,3;
效果如下:
mysql> SELECT art_id, art_pdate FROM ecos_article limit 0,5;
+--------+------------+
| art_id | art_pdate |
+--------+------------+
| 73 | 2005-12-01 |
| 74 | 2005-12-01 |
| 75 | 2005-12-01 |
| 76 | 2005-12-01 |
| 77 | 2005-12-01 |
+--------+------------+

mysql> SELECT art_id, art_pdate
-> FROM ecos_article
-> WHERE art_id>75 limit 0,1
-> UNION
-> SELECT art_id, art_pdate
-> FROM ecos_article
-> WHERE art_id<=75 ORDER BY art_id DESC limit 0,3;
+--------+------------+
| art_id | art_pdate |
+--------+------------+
| 76 | 2005-12-01 |
| 75 | 2005-12-01 |
| 74 | 2005-12-01 |
+--------+------------+