【马上结帖】取当前月的前12个月的记录，如何改下

[我辣椒哥]

select avg(jyprice)
from house
where datediff(month,dateandtime,getdate())=1

[-晴天]

select avg(jyprice)
from house
where datediff(month,dateandtime,getdate())<=12 

[叶子]

select avg(jyprice)
from house
where datediff(month,dateandtime,getdate())<12

[-晴天]

如果当月不算,则:

select avg(jyprice)
from house
where datediff(month,dateandtime,getdate())<=13 and datediff(month,dateandtime,getdate())>1