- 博客(6)
- 收藏
- 关注
原创 leetcode mysql题库解答 610. 判断三角形
select x,y,z,if(x+y+z>2*greatest(x,y,z),"Yes","No") as triangle from Triangle
2024-03-11 16:53:28
350
1
原创 leetcode mysql题库解答 175. 组合两表
select FirstName,LastName,City,State from Person pleft join Address a on p.Persona.PersonId
2024-03-11 16:28:09
320
1
原创 leetcode mysql题库解答 182. 查找重复的电子邮箱
select email from Person group by email having count(email)>1
2024-03-11 16:25:29
348
1
原创 leetcode mysql题库解答 183. 从不订购的客户
select name Customers from Customers cwhere c.id not in (select customerId from Orders)
2024-03-11 16:20:18
316
1
原创 leetcode mysql题库解答 181. 超过经理收入的员工
# Write your MySQL query statement belowselect a.name Employee from Employee a where a.salary>(select b.salary from Employee b where b.id = a.managerId)
2024-02-20 19:54:15
319
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人