SQL
愚於禹
这个作者很懒,什么都没留下…
展开
-
LeetCode SQL刷题笔记DAY2
1. 题1873if(employee_id % 2 = 1,(if(name like 'M%',0,salary)),0) AS bonusname like 'M%' 可用 left(name,1)2. 题627update salary set sex = if(sex = 'm','f','m')3. 题196delete from Person where Id not in ( select * from( select min(Id)原创 2022-05-01 19:38:22 · 177 阅读 · 0 评论 -
LeetCode SQL刷题笔记DAY3
1. 题1448GROUP_CONCAT(DISTINCT PRODUCT) AS products多列压缩select sell_date,count(distinct product) AS num_sold,GROUP_CONCAT(DISTINCT PRODUCT) AS productsfrom Activitiesgroup by sell_date输入:Activities 表:+------------+-------------+| sell_date | prod原创 2022-05-01 19:32:33 · 291 阅读 · 0 评论