连续根据两个字段排序

-- 升序首先以年字段排序，然后以月字段排序
select * from BD_TREND where type='国土资源交易额' and area_name='市本级' order by year,month;

--降序
select * from BD_TREND where type='国土资源交易额' and area_name='市本级' order by year desc,month desc;