SELECT EXTRACT(YEAR FROM NOW()) YEAR
UNION
SELECT EXTRACT(YEAR FROM NOW()) -1 YEAR
UNION
SELECT EXTRACT(YEAR FROM NOW()) -2 YEAR
UNION
SELECT EXTRACT(YEAR FROM NOW()) -3 YEAR
UNION
SELECT EXTRACT(YEAR FROM NOW()) -4 YEAR
UNION
SELECT EXTRACT(YEAR FROM NOW()) -5 YEAR
UNION
SELECT EXTRACT(YEAR FROM NOW()) -6 YEAR
UNION
SELECT EXTRACT(YEAR FROM NOW()) -7 YEAR
UNION
SELECT EXTRACT(YEAR FROM NOW()) -8 YEAR
UNION
SELECT EXTRACT(YEAR FROM NOW()) -9 YEAR
mysql查询最近十年
最新推荐文章于 2022-11-03 18:00:14 发布