select * from 订单 where substr(订购日期,1,4) = '${参数名}'
参考：
SELECT DISTINCT STRFTIME('%Y',订购日期) AS 年份 FROM 订单 ORDER BY 订购日期
1min目标场景问卷
立即参与
