题解 |
https://www.nowcoder.com/practice/c7734db33854477aa94ae238a3390435
#使用like模糊查询 select order_num,order_date from Orders where order_date like '2020-01%' order by order_date #使用date_format函数查询 select order_num, order_date from Orders where date_format(order_date,'%Y%m') =202001 order by order_date #补充一个position函数 select order_num,order_date from Orders where position('2020-01' in order_date) order by order_date