Myron2022
Myron2022
全部文章
分类
题解(2)
归档
标签
去牛客网
登录
/
注册
Myron2022的博客
全部文章
(共2篇)
题解 | #商品交易(网易校招笔试真题)#
select g.id,name,weight,sum(count) sums from goods g join trans t on g.id = t.goods_id group by g.id having sums>20 and weight<50 order by g.id;
Mysql
2022-01-14
0
173
题解 | #删除emp_no重复的记录,只保留最小的id对应的记录。#
select min(id) as min_id from titles_test group by emp_no delete from titles_test where id not in (select t.min_id from (select min(id) as min_id from...
Mysql
2022-01-12
0
140