一、前言
来源:leetcode
二、要点
1. 1485:GROUP_CONCAT()
- GROUP_CONCAT():分组 使用GROUP_CONCAT()拼接 默认为升序并按逗号分隔
select sell_date, count(distinct product) as num_sold,
GROUP_CONCAT(DISTINCT product ORDER BY product ASC SEPARATOR ',') AS products
from Activities
group by sell_date
运行结果:
2. 1495:时间函数
LEFT()函数:https://www.begtut.com/sql/func-mysql-left.html
- REGEXP语法:
https://www.cnblogs.com/timssd/p/5882742.html
https://www.cnblogs.com/zhaopanpan/p/10133224.html - DATE_FORMAT()函数:https://www.w3school.com.cn/sql/func_date_format.asp
- EXTRACT()函数:https://www.runoob.com/sql/func-extract.html
- ==DATEDIFF()==函数:https://www.runoob.com/sql/func-datediff-mysql.html
- YEAR()函数:https://blog.csdn.net/moakun/article/details/82528829
- MONTH()函数:https://www.yiibai.com/mysql/month.html
示例:2020年6月的十种表达方式
来源:https://leetcode-cn.com/problems/friendly-movies-streamed-last-month/solution/date_formattprogram_datey-m-2020-06-by-richard-95/