題解 |
http://www.fangfengwang8.cn/practice/c7734db33854477aa94ae238a3390435
#使用like模糊查詢
select order_num,order_date
from Orders
where order_date like '2020-01%'
order by order_date
#使用date_format函數(shù)查詢
select order_num, order_date
from Orders
where date_format(order_date,'%Y%m') =202001
order by order_date
#補(bǔ)充一個(gè)position函數(shù)
select order_num,order_date
from Orders
where position('2020-01' in order_date)
order by order_date
投遞淘天集團(tuán)等公司10個(gè)崗位