题解 |
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
之前面了一家外包的大模型，基本上都能答出来，那面试官感觉还没我懂，然后把我挂了，我都还没嫌弃他是外包，他把我挂了……
投递阿里云等公司9个岗位