题解 |
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
海康威视公司福利 1029人发布